Pierre wrote:
I suspect the assigned value has to be one of TRUE, FALSE, -1, 1 or 0
My curiosity got the better of me- the default value in the designer can
be set to YES or NO and this works for me. However, in a SQL update
you'd have to specify
"UPDATE mytable SET myboolfield = TRUE"
If you did
"UPDATE mytable SET myboolfield = YES" or even
"UPDATE mytable SET myboolfield = 'YES'"
it would generate an error.
I have just tried the OOo database and the boolean fields behave as I'd
expect,
--
Pierre
Worrigee, NSW,
,-._|\
/ Oz \
\_,--._/
v
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
