Forum > General

Code For Sqlite3 Question

(1/1)

nugax:
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:
Just ignore the autoincrement column. For example: col1 is autoincrement, col2 varchar and col3 integer, then:

INSERT INTO table1 (col2, col3) VALUES ('Pascal', 3);

Navigation

[0] Message Index