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

Re: MS Access help with boolean values

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Scott Walter <sdw1(at)geneseo(dot)edu>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MS Access help with boolean values
Date: 2001-04-06 05:08:04
Message-ID: 4.2.0.58.20010406070335.00a46d70@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgsql-odbc
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


In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-04-06 06:10:37
Subject: Re: MS Access help with boolean values
Previous:From: Hiroshi InoueDate: 2001-04-06 03:43:45
Subject: Re: Recognize unique indexes

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