iOS Question insert in a table of a sqlite db, with primary key autoincrement

[moore_it]

I created a table with this sqlite command :

CREATE TABLE IF NOT EXISTS table (id integer primary key autoincrement,a TEXT,b TEXT)

When i enter a sqlite command:

INSERT INTO table VALUES('a' 'b')

compiler respond ...

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "'a'": syntax error)

How work the autoincrement ???

Thanks in advice
Toni

 

[LucaMs]

pass null for it

 

[moore_it]

yes it work

Thanks
(Grazie)

 

[LucaMs]

Prego (y.w.)