Skip site navigation (1) Skip section navigation (2)

RE: ODBC handling of bools?

From: "Francis Solomon" <francis(at)stellison(dot)co(dot)uk>
To: "Stephen Davies" <scldad(at)sdc(dot)com(dot)au>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: ODBC handling of bools?
Date: 2000-12-18 13:39:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
Hi Stephen,

To test boolean values I use:

SELECT * FROM member WHERE weekends='t'

... and it works just fine through the ODBC driver.
(ODBC 6.50, PostgreSQL 7.02).

Hope this helps

Francis Solomon

> 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 ?

In response to

pgsql-interfaces by date

Next:From: Katsuyuki TanakaDate: 2000-12-18 13:41:48
Subject: jdbc connectint ot db
Previous:From: Peter MountDate: 2000-12-18 09:46:42
Subject: RE: Connection Pooling...(Repost)...please do help...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group