B4J Question [Solved] SQLite Autoincrement Problem

[behnam_tr]

hi guys,


I have a database table that has a field called ID and the field is autoincrement.
Suppose it has 5 records whose IDs are from 1 to 5 respectively
Now I insert a record manually with ID 10
Next time when inserting a new record, it will automatically insert the number 11
I want to continue from number 6 for new recods. Is there a solution??

sorry for my bad english!
-------------------------
database :
tbl1 >> id,name

records :
1,"any name"
2,"any name"
3,"any name"
4,"any name"
5,"any name"
10,"any name"
------------------------

 

[MicroDrie]

Anyone care to check this?

With the risk of damaging the whole database with a corrupt sqlite_sequence table when inserting after the gap?

 

[Mahares]

damaging the whole database with a corrupt sqlite_sequence table

Very wise of you to stay away from tampering with the sqlite_sequence table. The docs I read about it discourage manipulating it, in particular the docs from the official sqlite web site: Here is an excerpt:
'making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. Make sure you know what you are doing before you undertake such changes'