Code For Sqlite3 Question lazarus / 62-General ---------------------------------------------------------------------- nugax · 2019-01-10 19:17 Can someone give me the sql statement pascal uses to enter an auto incremented field? example: assume field id is auto-increment INSERT INTO table (col1, col2) VALUES ("1", "2"); I want field id auto incremented, then 1,2 in the respective col I tried this and get errors. ---------------------------------------------------------------------- GAN · 2019-01-10 20:29 Just ignore the autoincrement column. For example: col1 is autoincrement, col2 varchar and col3 integer, then: INSERT INTO table1 (col2, col3) VALUES ('Pascal', 3);