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.
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... |