Delphi Error

From: Fabrizio Giammatteo <fgiamma(at)fgiamma(dot)org>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Delphi Error
Date: 1999-09-07 06:27:42
Message-ID: 37D4B05E.A9DA7A8D@fgiamma.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi,
I'm using PsqlODBC (v06-40-0007) on a win 98 machine to access data on a
Linux Suse 6.1 Server.

I've PostgreSQL version 6.5 on my server machine and all seems to work
fine. But if I've a Memo Box, and I press more than one time the button
"refresh", the program crash. I've tried to modify ODBC settings and the
system works only if I uncheck "Text as a long varchar", but this limit
my memo fields to 254 chars.

If I uncheck "Text as a long varchar" and increase "Max varchar" over
254 the system crash too.

Can you help me ?

Thanks

Here the logs and in attach the ODBC SQL.LOG

This is the win98 error:
------------------------------------------------------------------------------------

TESTPG ha provocato un errore di pagina non valida nel
modulo KERNEL32.DLL in 0167:bff87eb5.
Registri:
EAX=c00300f0 CS=0167 EIP=bff87eb5 EFLGS=00010212
EBX=006df748 SS=016f ESP=005dff98 EBP=005e0004
ECX=006e0000 DS=016f ESI=816122c4 FS=1887
EDX=388b5708 ES=016f EDI=4be50802 GS=0000
Byte all'indirizzo CS:EIP:
53 56 57 8b 30 83 7d 10 01 8b 4e 38 89 4d f8 75
Immagine dello stack:

This is the psqlODBC log
---------------------------------------------------------------------------------------------

DSN info:
DSN='PostgreSQL',server='www.allnet.it',port='5432',dbase='testpg',user='',passwd=''

readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'

conn_settings=''
translation_dll='',translation_option=''
conn = 55052412, SQLConnect(DSN='PostgreSQL', UID='fgiamma',
PWD='skywalker')
Global Options: Version='06.40.0007', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=0,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=55052412, query=' '
conn=55052412, query='set DateStyle to 'ISO''
conn=55052412, query='set geqo to 'OFF''
conn=55052412, query='set ksqo to 'ON''
conn=55052412, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=55052412, query='select relname, usename, relhasrules from
pg_class, pg_user where relkind = 'r' and relname like 'testpg' and
relname !~ '^pg_|^dd_' and relname !~ '^xinv[0-9]+' and
int4out(usesysid) = int4out(relowner)order by relname'
[ fetched 1 rows ]
conn=55052412, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull,
c.relhasrules from pg_user u, pg_class c, pg_attribute a, pg_type t
where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid
and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'testpg'
order by attnum'
[ fetched 3 rows ]
conn=55052412, query='select u.usename, c.relname, a.attname,
a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull,
c.relhasrules from pg_user u, pg_class c, pg_attribute a, pg_type t
where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid
and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'testpg'
order by attnum'
[ fetched 3 rows ]
conn=55052412, query='select c.relname, i.indkey, i.indisunique,
i.indisclustered, c.relhasrules from pg_index i, pg_class c, pg_class d
where c.oid = i.indexrelid and d.relname = 'testpg' and d.oid =
i.indrelid'
[ fetched 1 rows ]
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
ORDER BY "codice" ASC '
[ fetched 9 rows ]
conn=55052412, query='SELECT COUNT(*) FROM "testpg" WHERE "codice"=3
AND "nome"='dddddd''
[ fetched 1 rows ]
conn=55052412, query='BEGIN'
conn=55052412, query='UPDATE "testpg" SET "note"='bòa ba

dddddd
dddddd' WHERE "codice"=3 AND "nome"='dddddd''
conn=55052412, query='COMMIT'
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
WHERE "codice"=3'
[ fetched 1 rows ]
conn=55052412, query='SELECT COUNT(*) FROM "testpg" WHERE "codice"=6
AND "nome"='aadsfdsafadsfa''
[ fetched 1 rows ]
conn=55052412, query='BEGIN'
conn=55052412, query='UPDATE "testpg" SET "note"='pkpkmsmssdddddssssd

d
dsaf
dsa
fsddsjjksijdu' WHERE "codice"=6 AND "nome"='aadsfdsafadsfa''
conn=55052412, query='COMMIT'
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
WHERE "codice"=6'
[ fetched 1 rows ]
conn=55052412, query='BEGIN'
conn=55052412, query='DELETE FROM "testpg" WHERE "codice"=5 AND
"nome"='ddddd''
conn=55052412, query='COMMIT'
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
WHERE (("codice" IS NULL OR "codice"> 6)) ORDER BY "codice" ASC '
[ fetched 3 rows ]
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
WHERE "codice"=6'
[ fetched 1 rows ]
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
WHERE ("codice"< 6) ORDER BY "codice" DESC '
[ fetched 4 rows ]
conn=55052412, query='SELECT "codice" ,"nome" ,"note" FROM "testpg"
WHERE "codice"=4'
[ fetched 1 rows ]

Attachment Content-Type Size
SQL.LOG application/x-unknown-content-type-log_auto_file 604.6 KB

Browse pgsql-interfaces by date

  From Date Subject
Next Message Andrew O'Callaghan 1999-09-07 07:27:17 insert interface
Previous Message Peter Mount 1999-09-07 06:03:18 Re: [INTERFACES] JDBC Documentation??