Thread: 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:
but this is very strange function there (which i am not understanding), why to use it? There is no other option?
Best,
Jacek
Attachment
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):
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
On 07/13/2018 06:56 AM, Łukasz Jarych wrote: > Hmm so maybe better is use text field here.... Well it really depends on what you want to do with the field. > > Best, > Jacek > -- Adrian Klaver adrian.klaver@aklaver.com