I have a VB5 application which uses ODBC 6.5 (2/4/00) to access a Postgresql 7.0.2
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 Consulting scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133
pgsql-interfaces by date
|Next:||From: Constantin Teodorescu||Date: 2000-12-17 09:43:55|
|Subject: Re: problems with german special chars using pgaccess
|Previous:||From: Henry C. Schmitt||Date: 2000-12-17 01:24:17|
|Subject: DBD-Pg 0.95 make test error|