From: Stephen Davies <scldad@sdc.com.au>
To: pgsql-interfaces@postgresql.org
Subject: ODBC handling of bools?
Date: Sun, 17 Dec 2000 20:05:42 +1030
Message-ID: <200012170935.UAA13378@mustang.sdc.com.au> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: scldad@sdc.com.au
Subject: Re: ODBC handling of bools?
In-Reply-To: <200012170935.UAA13378@mustang.sdc.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox