Q:

Inserting records with SQLite

What is the SQLite statement for "insert"?
I have tried 
insert into table1 values(field1,field2) values (?,?)

but this returns an error in the statement -- how do I do this?

A:

The correct syntax for the insert statement is here:
INSERT INTO table (column1, [column2, ... ]) VALUES (value1, [value2, ...])

Note that you have put the VALUES keyword before the list of column names.

