MS Access help with boolean values

From: Scott Walter <sdw1(at)geneseo(dot)edu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: MS Access help with boolean values
Date: 2001-04-05 20:39:46
Message-ID: 5.0.2.1.0.20010405161914.009ee460@chaos.geneseo.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-04-06 03:43:45 Re: Recognize unique indexes
Previous Message Johann Zuschlag 2001-04-05 19:05:04 Tracked down an error...