moore_it Well-Known Member Licensed User Longtime User Dec 16, 2014 #1 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
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
moore_it Well-Known Member Licensed User Longtime User Dec 16, 2014 #3 yes it work Thanks (Grazie) Upvote 0