Postgres Pro
Downloads
Home   >   mailing lists

Thread: MS Access help with boolean values

MS Access help with boolean values

From
Scott Walter
Date:
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.

Re: MS Access help with boolean values

From
Jean-Michel POURE
Date:
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@postgresql.org so that your
>message can get through to the mailing list cleanly

Re: MS Access help with boolean values

From
Hiroshi Inoue
Date:
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