From: | "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
---|---|
To: | "Ets ROLLAND" <ets(at)rolland-fr(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pb with boolean between MS-Access and PostgreSQl 8.0.3 |
Date: | 2005-07-12 16:51:02 |
Message-ID: | 004d01c58701$ec78e470$8b8c1dc3@zlatko58zaczpv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 -----
From: Ets ROLLAND
To: pgsql-general(at)postgresql(dot)org
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-07-12 16:51:42 | Re: Japanese words not distinguished |
Previous Message | Bjørn T Johansen | 2005-07-12 16:29:13 | Windows version of PostgreSQL 8.x? |