Re: Pb with boolean between MS-Access and PostgreSQl 8.0.3 - Mailing list pgsql-general

From Zlatko Matic
Subject Re: Pb with boolean between MS-Access and PostgreSQl 8.0.3
Date
Msg-id 004d01c58701$ec78e470$8b8c1dc3@zlatko58zaczpv
Whole thread Raw
In response to Pb with boolean between MS-Access and PostgreSQl 8.0.3  ("Ets ROLLAND" <ets@rolland-fr.com>)
List pgsql-general
Hello Ets!
 
I think that you should use Format, so that Access can understands bools.
I have done it in this way:
In Access Query Builder use alias for field, for example
    AliasName: Format([FieldName])
In Criteria use "True" or "False" instead of -1
 
Tell me if it works for you. In my case it worked fine...
 
Greetings,
 
Zlatko
----- Original Message -----
Sent: Tuesday, July 12, 2005 4:16 PM
Subject: [GENERAL] Pb with boolean between MS-Access and PostgreSQl 8.0.3


Hello !
 
I use psql ODBC v.8.00.0101 with MS-Access 2002 under XP Pro.
If I use a System Data Source configured with :
Datasource using :
- Bool AS Char,
- True is -1.
So Query with criteria "true" work
but checked fields don't work !?
 
If Datasource use :
- Bool NOT char,
- True is -1.
So Query with criteria True don't work,
but checked fields work !?
 
How can I obtain an good support for logical
between MS-Access and PostgreSQL 8.0.3 ?
 
Thanks for any explaination...
 
Best regards
 

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Windows version of PostgreSQL 8.x?
Next
From: Tom Lane
Date:
Subject: Re: Japanese words not distinguished