From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Odbc parser error |
Date: | 1998-09-17 08:34:51 |
Message-ID: | 8440.980917@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
Hi all,
Seems that ODBC driver have some problems while it translate Access
commands.
I created a form with a subform joined by two columns.
after the Access Addnew event, log file returns the following error:
-----------------------------------------------------------------------
conn=75511800, query='SELECT "risanamento"."oid" FROM "risanamento" WHERE (("distretto" = '' ) AND ("progressivo" = NULL ) ) '
ERROR from backend during send_query: 'ERROR: parser: parse error at or near "null"'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------------------
NB: Note that parser translate ("progressivo" = NULL) instead of
("progressivo" IS NULL).
I suspect that problem is linked with column type, in fact
"progressivo" is an int4. I changed this field to char and now it
works:
----------------------------------------------------------------------------------
conn=92477940, query='SELECT "risanamento"."oid" FROM "risanamento" WHERE (("distretto" = '' ) AND ("progressivo" = '' ) ) '
------------------------------------------------------------------------------------
"progressivo" is a counter field and it must be numeric.
Any hints will be appreciate.
Thank you in advance,
Marco Pollachini mailto:sferac(at)bo(dot)nettuno(dot)it
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares | 1998-09-17 13:31:58 | Re: NOTICE: _outNode: don't know how to print type 715 |
Previous Message | Michael Meskes | 1998-09-17 08:18:52 | Re: [HACKERS] Transaction system (proposal for 6.5) |
From | Date | Subject | |
---|---|---|---|
Next Message | Midwest Online | 1998-09-17 13:51:25 | Re: [INTERFACES] getting "fe_setauthsvc: invalid name" error |
Previous Message | Apyo s.r.o. | 1998-09-16 18:42:37 | confused about backslashes |