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