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

RE: [INTERFACES] Re: NEW ODBC DRIVER

From: Felix Morley Finch <felix(at)crowfix(dot)com>
To: interfaces postgres <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: RE: [INTERFACES] Re: NEW ODBC DRIVER
Date: 1998-05-11 19:33:38
Message-ID: 19980511193338.20758.qmail@crowfix.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
(I can't follow the original attributions)

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

I bet it's because -1 is all bits on.  Still brain damaged.  

-- 
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix(at)crowfix(dot)com
  PGP = 91 B3 94 7C E9 E8 76 2D   E1 63 51 AA A0 48 89 2F  ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

pgsql-interfaces by date

Next:From: Jackson, DeJuanDate: 1998-05-11 19:44:30
Subject: RE: [INTERFACES] Re: NEW ODBC DRIVER
Previous:From: David HartwigDate: 1998-05-11 19:20:58
Subject: Group/Order by not in target - Was [NEW ODBC DRIVER]

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