RE: [sqlite] BOOLEAN DEFAULT VALUE

[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.
> 
> http://www.sqlite.org/lang_createtable.html
> http://www.sqlite.org/lang_createtrigger.html
> 
> 
> Brad
> 
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/BOOLEAN-DEFAULT-VALUE-tp14361417p14362729.html
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] BOOLEAN DEFAULT VALUE

[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, 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]
> -
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/BOOLEAN-DEFAULT-VALUE-tp14361417p14362620.html
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] BOOLEAN DEFAULT VALUE

[Runspect]

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?

Thanks.
-- 
View this message in context: 
http://www.nabble.com/BOOLEAN-DEFAULT-VALUE-tp14361417p14361417.html
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-