Lazarus

Free Pascal => General => Topic started by: nugax on January 10, 2019, 08:17:32 pm

Title: Code For Sqlite3 Question
Post by: nugax on January 10, 2019, 08:17:32 pm

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.

Title: Re: Code For Sqlite3 Question
Post by: GAN on January 10, 2019, 09:29:49 pm

Just ignore the autoincrement column. For example: col1 is autoincrement, col2 varchar and col3 integer, then:

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