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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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