RE: ODBC handling of bools?
От | Francis Solomon |
---|---|
Тема | RE: ODBC handling of bools? |
Дата | |
Msg-id | NEBBIFFPELJMCJAODNPKGEAMCEAA.francis@stellison.co.uk обсуждение исходный текст |
Ответ на | ODBC handling of bools? (Stephen Davies <scldad@sdc.com.au>) |
Список | 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 ?
В списке pgsql-interfaces по дате отправления: