Hello everyone
Can anyone please tell me how to reset an AUTOINCREMENT field after deleting all records?
I learnt that I have to delete the sqlite_sequence table.
I did so but still the autoincrement field not reset.
Code:cnn.Execute "Delete from Tbl_Person"I tried also to update the sqlite_sequence table but without success.Code:cnn.Execute "Delete from sqlite_sequence where Name='Tbl_Person '"
ThanksCode:cnn.Execute "UPDATE SQLITE_SEQUENCE SET SEQ=0 WHERE NAME='Tbl_Person'