Handlind booleans Postgresql-Access
Hi Guys,
i created boolean in postgresql table (in attachment) but linked table in
Access see this as short text.
I checked in odbc option Bools as Char to false and True is -1 as true.but
still tihs is not working.
I found linke here:
http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean-mess.html
but this is very strange function there (which i am not understanding), why
to use it? There is no other option?
Best,
Jacek
Attachments:
On 07/13/2018 02:19 AM, Łukasz Jarych wrote:
Hi Guys,
i created boolean in postgresql table (in attachment) but linked table
in Access see this as short text.I checked in odbc option Bools as Char to false and True is -1 as
true.but still tihs is not working.
Define working.
I found linke here:
http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean-mess.html
but this is very strange function there (which i am not understanding),
why to use it? There is no other option?
Because Postgres has true boolean fields and Access does not.
Best,
Jacek
--
Adrian Klaver
adrian.klaver@aklaver.com
Hmm so maybe better is use text field here....
Best,
Jacek
pt., 13 lip 2018 o 15:36 Adrian Klaver <adrian.klaver@aklaver.com>
napisał(a):
Show quoted text
On 07/13/2018 02:19 AM, Łukasz Jarych wrote:
Hi Guys,
i created boolean in postgresql table (in attachment) but linked table
in Access see this as short text.I checked in odbc option Bools as Char to false and True is -1 as
true.but still tihs is not working.Define working.
I found linke here:
http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean-mess.html
but this is very strange function there (which i am not understanding),
why to use it? There is no other option?Because Postgres has true boolean fields and Access does not.
Best,
Jacek--
Adrian Klaver
adrian.klaver@aklaver.com