Runspect <[EMAIL PROTECTED]> wrote:
I got a BOOLEAN field. It's defined: NOT NULL.
when a new record is inserted, how to put a Boolean Default Value as
FALSE?
SQLite doesn't have a dedicated boolean type. You just store them as
integer, zero for false and nonzero for true. So make it
create table myTable(col BOOLEAN default 0);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------