Re: Pb with boolean between MS-Access and PostgreSQl 8.0.3
От | Zlatko Matic |
---|---|
Тема | Re: Pb with boolean between MS-Access and PostgreSQl 8.0.3 |
Дата | |
Msg-id | 004d01c58701$ec78e470$8b8c1dc3@zlatko58zaczpv обсуждение исходный текст |
Ответ на | Pb with boolean between MS-Access and PostgreSQl 8.0.3 ("Ets ROLLAND" <ets@rolland-fr.com>) |
Список | 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 ROLLANDSent: Tuesday, July 12, 2005 4:16 PMSubject: [GENERAL] Pb with boolean between MS-Access and PostgreSQl 8.0.3Hello !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" workbut 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 logicalbetween MS-Access and PostgreSQL 8.0.3 ?Thanks for any explaination...Best regards
В списке pgsql-general по дате отправления: