Skip site navigation (1) Skip section navigation (2)

Re: boolean values and MS Access

From: David Gardner <David(dot)Gardner(at)yucaipaco(dot)com>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: boolean values and MS Access
Date: 2007-05-25 00:22:45
Message-ID: C975BFE03CC5DE4999143A5BEA9FB51501F54328E1@yucex.lax.yucwin (view raw or flat)
Thread:
Lists: pgsql-odbc
Please dis-regard my email. I found someone with a similar problem and the solution in the mailing list archives.
http://archives.postgresql.org/pgsql-general/2006-12/msg00415.php

Apologies for not doing this before I posted.

---
David Gardner, IT
The Yucaipa Companies
(310) 228-2855
________________________________
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of David Gardner
Sent: Thursday, May 24, 2007 4:08 PM
To: 'pgsql-odbc(at)postgresql(dot)org'
Subject: [ODBC] boolean values and MS Access

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

In response to

Responses

pgsql-odbc by date

Next:From: Ben TrewernDate: 2007-05-25 11:15:14
Subject: Re: Setting null to date field from Delphi.
Previous:From: Adam MDate: 2007-05-25 00:16:00
Subject: Problem with 8.2.x MSM ODBC drivers in Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group