sometimes a boolean Yes/No field appears as -1/0 and sometimes as
checkboxes. What controls this, and is it indicative in any way of how
the data field itself is defined?
On topic: Is it always safe to do a query on an Access table through the
MS ODBC drivers and test a Yes/No field using 1/0 rather than -1/0? I
realize why Access stores booleans that appear as -1. What I'm wondering
is if the ODBC layer masks this from the developer.
SELECT *
FROM mytable
WHERE booleanfield = 1
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
