Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Re: NEW ODBC DRIVER

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: Sbragion Denis <infotecn(at)tin(dot)it>
Cc: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>, interfaces postgres <pgsql-interfaces(at)postgreSQL(dot)org>, "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>, Hannu Krosing <hannu(at)trust(dot)ee>
Subject: Re: [INTERFACES] Re: NEW ODBC DRIVER
Date: 1998-05-11 18:42:16
Message-ID: 35574688.C434D15@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
Sbragion Denis wrote:

> Hello,
>
> At 08.35 11/05/98 -0400, Byron Nikolaidis wrote:
> >As for the BOOL problem, I tried to return it as a SQL_BOOL, but Access
> >displayed it as 0=FALSE, and (-1)=TRUE.  Why does TRUE translate to a -1, I
> >have no idea.  But for that reason, I chose to make it a character type
> >instead.
>
> This is an MS brain damage implementation of Booleans. It is used this way
> starting from MS Access 1.0 up to VB 5.0. I don't know why MS decided to
> use this convention in the early MS Access 1.0 age but for compatibility
> reason they had to retain it up to the most recent version of their
> development programs.
>
>

OK,

I'm gonna make it an option. But, as I mentioned before, there are some
weirdnesses with Access.  Here's another weird thing with the way it handles
NULL SQL_BIT columns.

If I have my Postgres bool column, and it contains a NULL, Access automatically
displays it as "0".  Then if I try to update the record, it uses the "0" in the
where clause.  Well guess what, no records are updated because the "0" doesn't
match the NULL in the record, and you get this ugly message about a user
conflict!

When BOOLS are handled as character data, this doesnt happen of course.

Anybody  got any ideas about this?

Byron



In response to

Responses

pgsql-hackers by date

Next:From: David HartwigDate: 1998-05-11 19:20:58
Subject: Group/Order by not in target - Was [NEW ODBC DRIVER]
Previous:From: David GouldDate: 1998-05-11 18:33:44
Subject: Re: [HACKERS] Automatic type conversion

pgsql-interfaces by date

Next:From: David HartwigDate: 1998-05-11 19:20:58
Subject: Group/Order by not in target - Was [NEW ODBC DRIVER]
Previous:From: The Hermit HackerDate: 1998-05-11 18:10:00
Subject: Parse error at or near char

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group