DB primary key and insert

[ljcomp]

Hi All
I have a simple database the table has been created:-

SQL1.ExecNonQuery("CREATE TABLE IF NOT EXISTS tree (ID INTEGER PRIMARY KEY , common TEXT , botanical TEXT)")

I now need to insert as:-

SQL1.ExecNonQuery2("INSERT INTO tree VALUES('id', ?, ?)", Array As Object(TreeText1.Text, TreeText2.text ))

This doesn't work.
Can anyone show me how I should insert to the table correctly. I want the ID col to be auto increment as primary key.

Cheers
LJ

 

[Erel]

Here:

"INSERT INTO tree VALUES(null, ?, ?)", Array As Object(TreeText1.Text, TreeText2.text ))

 

[ljcomp]

Thank you