Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.8.8) with ESMTP id EAA16213 for ; Thu, 17 Sep 1998 04:35:11 -0400 (EDT) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id KAA09596 for ; Thu, 17 Sep 1998 10:35:02 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zJbIF-0000Mh-00; Thu, 17 Sep 1998 10:28:07 +0000 Date: Thu, 17 Sep 1998 10:34:51 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <8440.980917@bo.nettuno.it> To: pgsql-interfaces@postgresql.org Subject: Odbc parser error Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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@bo.nettuno.it