Hello,
Why it does not work?
In every row ID = 0. ID does not incremented for each record but remains at 0
Why it does not work?
B4X:
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