From: | David Gardner <David(dot)Gardner(at)yucaipaco(dot)com> |
---|---|
To: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | boolean values and MS Access |
Date: | 2007-05-24 23:08:25 |
Message-ID: | C975BFE03CC5DE4999143A5BEA9FB51501F54328DF@yucex.lax.yucwin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I have a boolean column in one of my tables in pgsql. What I would like to do is:
SELECT * FROM public_table WHERE public_table.bShowReport=TRUE;
But I get a data mis-match, although this query works fine from pgAdmin3.
I know Access stores bools a little weird so I have tried public_table.bShowReport=-1; and public_table.bShowReport="TRUE"
I have tried this as a pass-through query, and it works but I want to feed this query into a report and Access limits your ability to use sub-reports if the parent report is based upon a pass-through query.
I have played around with the "Bools as Char" and "True is -1" settings.
With "Bools as Char" selected I run into problems when Access attempts to edit the field. With "True is -1" I get ODBC Error #7 boolean:=integer
I have tried this with 8.02.04 and 8.02.02. I am hoping there is just some little bit that I am missing.
---
David Gardner, IT
The Yucaipa Companies
(310) 228-2855
From | Date | Subject | |
---|---|---|---|
Next Message | Adam M | 2007-05-25 00:16:00 | Problem with 8.2.x MSM ODBC drivers in Windows |
Previous Message | Ludek Finstrle | 2007-05-21 06:49:38 | Re: postgres odbc with crystal reports server xi on linux |