Re: MS Access help with boolean values

Hello Scott,

I have come through similar problems but did not enquire because I
transformed boolean into int2 type, which gave me good results with linked
tables.
Unfortunately, I cannot tell you more ...

Greetings from Jean-Michel POURE, Paris

At 16:39 05/04/01 -0400, you 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)"
>
>I have tried the following, all of which have given me the same error message:
> "SELECT ......... FROM organizations WHERE FROM
> (((organizations.submit_flag)=-1));"
> "SELECT ......... FROM organizations WHERE FROM
> (((organizations.submit_flag)=Yes));"
> "SELECT ......... FROM organizations WHERE FROM
> (((organizations.submit_flag)=True));"
>
>I am using:
> MS Access '97 w/ pgsql-odbc-07.01.0004 and PostgreSQL 7.0.3
>
>I am kind of new to ODBC, so I apologize in advance, but I would
>appreciate any help.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly