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

ms-access and booleans ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ms-access and booleans ?
Date: 2004-01-18 03:08:15
Message-ID: 4009F89F.9070402@gmx.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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

How can have booleans that don't break my Access front-end ?


cu
    Andreas


Responses

pgsql-odbc by date

Next:From: Richard HuxtonDate: 2004-01-19 09:36:46
Subject: Re: error 3669 in psql 7.2
Previous:From: Robert RoeblingDate: 2004-01-16 21:08:01
Subject: Newbie unable to connect through iODBC

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