On Thu, 30 Jan 2014 10:49:39 -0500
Stephen Chrzanowski <[email protected]> wrote:
> What I might suggest you do is instead of checking GetBoolean (Since
> it is extremely picky apparently) is use GetInteger != 0. If the
> result is ZERO this will return FALSE. (1 != 0 = TRUE; 0 != 0 =
> FALSE) If the result is anything else, you'll return TRUE.
or define a constraint
colname boolean check (colname in ('Y', 'N'))
Of course you can use 0 and 1, but there's no technical advantage, and
very often 'Y' and 'N' turn out to be handy for reporting purposes.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
