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