SQL1.ExecNonQuery2

[ciginfo]

Hello,
Why it does not work?

SQL1.ExecNonQuery("CREATE TABLE table1 (ID AUTO_INCREMENT PRIMARY KEY, MaDate LONG, MonNom TEXT, MaLongitude DOUBLE, MaLatitude DOUBLE)") 
SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(Null, ?, ?, ?, ?)", Array As Object( now, nomchamp, longi, lati))

In every row ID = 0. ID does not incremented for each record but remains at 0

 

[Mahares]

Try the below. It will work for you. It will auto increment for you:

SQL1.ExecNonQuery("CREATE TABLE table1 (ID INTEGER PRIMARY KEY, MaDate LONG, MonNom TEXT, MaLongitude DOUBLE, MaLatitude DOUBLE)") 
SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(Null, ?, ?, ?, ?)", Array As Object( now, nomchamp, longi, lati))

Bonne journee