Message-Id: <200012170935.UAA13378@mustang.sdc.com.au>
To: pgsql-interfaces@postgresql.org
Subject: ODBC handling of bools?
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Sun, 17 Dec 2000 20:05:42 +1030
From: Stephen Davies <scldad@sdc.com.au>

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