From: | Michael Davis <mdavis(at)sevainc(dot)com> |
---|---|
To: | "'Stephen Davies'" <scldad(at)sdc(dot)com(dot)au>, "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | RE: ODBC handling of bools? |
Date: | 2000-12-17 15:41:41 |
Message-ID: | 01C06805.315C6D80.mdavis@sevainc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)sevainc(dot)com
-----Original Message-----
From: Stephen Davies [SMTP:scldad(at)sdc(dot)com(dot)au]
Sent: Sunday, December 17, 2000 2:36 AM
To: pgsql-interfaces(at)postgresql(dot)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(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2000-12-18 07:37:21 | Re: [HACKERS] Trigger |
Previous Message | Adam Lang | 2000-12-17 13:42:30 | Re: Connection Pooling....an interesting question!! (was..Connection Pooling...(Repost)...please do help...) |