J
Jack Leach
The Boolean datatype will always default to False, as will a Yes/No field in
a table. Both the Boolean datatype and a Yes/No field convert to an integer
on a system level (0 is false (default) and -1 is true (I think maybe even
anything except 0 equates to true)).
Allen has some insight to this:
http://allenbrowne.com/NoYesNo.html
Personally I use a byte field with no default value (null's for all new
records) for situations such as these.
hth
--
Jack Leach
www.tristatemachine.com
"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
a table. Both the Boolean datatype and a Yes/No field convert to an integer
on a system level (0 is false (default) and -1 is true (I think maybe even
anything except 0 equates to true)).
Allen has some insight to this:
http://allenbrowne.com/NoYesNo.html
Personally I use a byte field with no default value (null's for all new
records) for situations such as these.
hth
--
Jack Leach
www.tristatemachine.com
"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)