(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