Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBHFfV607982 for ; Sun, 17 Dec 2000 10:41:31 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 23836 invoked by uid 89); 17 Dec 2000 15:41:48 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by mail.phoenixdsl.com with SMTP; 17 Dec 2000 15:41:48 -0000 Received: by localhost with Microsoft MAPI; Sun, 17 Dec 2000 08:41:47 -0700 Message-ID: <01C06805.315C6D80.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Stephen Davies'" , "pgsql-interfaces@postgresql.org" Subject: RE: ODBC handling of bools? Date: Sun, 17 Dec 2000 08:41:41 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/144 X-Sequence-Number: 488 In the ODBC driver configuration (click on the Driver button) and set "Bools as Char" to on. Michael Davis Database Architect and Senior Software Engineer, Seva Inc. Office: 303-460-7360 Fax: 303-460-7362 Mobile: 720-320-6971 Email: mdavis@sevainc.com -----Original Message----- From: Stephen Davies [SMTP:scldad@sdc.com.au] Sent: Sunday, December 17, 2000 2:36 AM To: pgsql-interfaces@postgresql.org Subject: ODBC handling of bools? Hello. I have a VB5 application which uses ODBC 6.5 (2/4/00) to access a Postgresql 7.0.2 database. Everything works just fine except for booleans. I manually generate the SQL to be sent to the ODBC driver ] eg select * from member where weekends or select * from member where weekends=true but this fails because somewhere in the driver, this is translated to select * from member where weekends <> 0 and this causes an error because there is no operator to compare bools and integers. I have tried with the "bools as char" option on and off with no effect. I thought that this stuff had been fixed a couple of years ago. Did it break again or am I just missing something basic? How does one make bool tests work ? Cheers and thanks, Stephen Davies ======================================================================== Stephen Davies Consulting scldad@sdc.com.au Adelaide, South Australia. Voice: 08-8177 1595 Computing & Network solutions. Fax: 08-8177 0133