Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group