Re: MS Access help with boolean values - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: MS Access help with boolean values
Date
Msg-id 3ACD5DDD.90175AE@tpf.co.jp
Whole thread Raw
In response to MS Access help with boolean values  (Scott Walter <sdw1@geneseo.edu>)
List 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

pgsql-odbc by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: MS Access help with boolean values
Next
From: "Tomas Fulajtar"
Date:
Subject: Re: Recognize unique indexes