RE: [sqlite] BOOLEAN DEFAULT VALUE

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. > > http://www.sqlite.org/lang_createtable.html

Re: [sqlite] BOOLEAN DEFAULT VALUE

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, z

RE: [sqlite] BOOLEAN DEFAULT VALUE

> 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