RE: [sqlite] BOOLEAN DEFAULT VALUE

2007-12-16 Thread Runspect
The documentation is obscure on that point. Than you. Brad Stiles 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? > > By reading the documentation. > >

Re: [sqlite] BOOLEAN DEFAULT VALUE

2007-12-16 Thread Runspect
Thank you. Igor Tandetnik wrote: > > 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,

RE: [sqlite] BOOLEAN DEFAULT VALUE

2007-12-16 Thread Brad Stiles
> 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? By reading the documentation. http://www.sqlite.org/lang_createtable.html http://www.sqlite.org/lang_createtrigger.html Brad