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

Re: ms-access and booleans ?

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ms-access and booleans ?
Date: 2004-01-20 15:07:21
Message-ID: 200401200707.21552.aklaver@comcast.net (view raw or flat)
Thread:
Lists: pgsql-odbc
On Monday 19 January 2004 07:36 am, Jeff Eckermann wrote:
> --- Andreas <maps(dot)on(at)gmx(dot)net> wrote:
> > Hi,
> >
> > I transferred a couple of tables from an Access MDB
> > to Postgres.
> > Among the involved column-types are booleans.
> >
> > I could dump the contend of the Access table to PG
> > via an odbc linked table.
> >
> > In  psql  I can run :
> >     SELECT count(*) FROM my_table WHERE
> > some_boolean;
> > It shows some number as expected.
> >
> > I Access I get an Error:
> > ODBC-Call failed.
> > Error: Operator doesn't exist:  boolean = integer
> > (#7)
> >
> > In the System-DSN I have
> > Bool as Char :   NO
> > True is -1 :    YES
>
> You should have success by playing with these
> settings.  I use different settings, but that is a
> historical matter. I believe that the ODBC driver
> handling of booleans for MS Access has been optimized
> somewhat in recent releases.  Probably just setting
> "bool as char" to true will do it.  But I admit that I
> haven't played with these lately, not wanting to mess
> up a working setup.
>
> > How can have booleans that don't break my Access
> > front-end ?
> >
> >
> > cu
> >     Andreas
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> > unregister command
> >     (send "unregister YourEmailAddressHere" to
>
> majordomo(at)postgresql(dot)org)
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly
 
The way I have handled this is to avoid check boxes and use a combo box 
instead. I supply the values as True;1 ,False;0 and bind the field to the 
second value of each pair. To make things easier for data entry I hide the 
second column by giving it a width of 0".  In my DSN settings I check bool as 
char and uncheck true as -1. 
-- 
Adrian Klaver	
aklaver(at)comcast(dot)net

In response to

pgsql-odbc by date

Next:From: anthonyDate: 2004-01-20 18:00:47
Subject: Crystal Reports 8, psqlODBC driver and stored procedures
Previous:From: Jeff EckermannDate: 2004-01-20 01:46:24
Subject: Re: ms-access and booleans ?

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