boolean values and MS Access

[David Gardner <David(dot)Gardner(at)yucaipaco(dot)com>]

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