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

Re: MS Access help with boolean values

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Scott Walter <sdw1(at)geneseo(dot)edu>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MS Access help with boolean values
Date: 2001-04-06 06:10:37
Message-ID: 3ACD5DDD.90175AE@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Scott Walter wrote:
> 
> One of the attributes in my db is of type boolean, which when linked to MS
> Access assumes type Yes/No.  However, when I attempt to query through
> Access for all tuples that are 'true' I get the following messages returned
> by Access, and the log file was no help.
> 
> "ODBC--call failed"
> 
> "Error while executing the query (non-fatal);
> ERROR: Unable to identify an operator '=' for types 'bool' and 'int4'
>         You will have to retype this query using an explicit cast (#-1)"
> 

Check the driver option "Bools as char".

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Tomas FulajtarDate: 2001-04-06 06:52:03
Subject: Re: Recognize unique indexes
Previous:From: Jean-Michel POUREDate: 2001-04-06 05:08:04
Subject: Re: MS Access help with boolean values

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