CODEWITHSUNDEEP
sqliteblackberry
mindus
mindus

Reputation: 209

Blackberry sqlite boolean type

Can anybody tell me does BlackBerry Sqlite supports Boolean type or not?

 statement = database.createStatement("CREATE TABLE DEPT(Code TEXT,Description TEXT, Status Boolean)" );

Is that possible in blackberry sqlite?

Upvotes: 0

Views: 48

Answers (2)

Milen
Milen

Reputation: 8867

You can try: 

statement = database.createStatement("CREATE TABLE DEPT(Code TEXT,Description TEXT, Status INTEGER)" );

and make it NOT NULL DEFAULT(0)
Boolean is not supported...

Upvotes: 0

Giacomo Degli Esposti
Giacomo Degli Esposti

Reputation: 2452

I don't know if on Blackberry there is a standard or customized version of SQLite.

If it is a standard one, according to SQLite documentation (see: here) it does not support boolean type, you have to use 0 and 1.

Upvotes: 2

Related Questions