Received: from crowfix.com (qmailr@crowfix.crowfix.com [207.228.46.42]) by hub.org (8.8.8/8.7.5) with SMTP id PAA27005 for ; Mon, 11 May 1998 15:33:42 -0400 (EDT) Received: (qmail 20759 invoked by uid 501); 11 May 1998 19:33:38 -0000 Date: 11 May 1998 19:33:38 -0000 Message-ID: <19980511193338.20758.qmail@crowfix.com> From: Felix Morley Finch To: interfaces postgres Subject: RE: [INTERFACES] Re: NEW ODBC DRIVER X-Mailer: VM 6.34 under Emacs 20.2.1 (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@crowfix.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