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".
In response to
pgsql-odbc by date
|Next:||From: Tomas Fulajtar||Date: 2001-04-06 06:52:03|
|Subject: Re: Recognize unique indexes|
|Previous:||From: Jean-Michel POURE||Date: 2001-04-06 05:08:04|
|Subject: Re: MS Access help with boolean values|