B4J Question SQLite problem with AUTOINCREMENT

[strupp01]

I have created a table in my program with the following liberation

SQL_DB.ExecNonQuery("CREATE TABLE IF NOT EXISTS Hilfsdatei_1(Zeilen_Nr INTEGER PRIMARY KEY AUTOINCREMENT, Zeilen_Text Text, Zeilen_Werte, Ergebnis Text, Einheit Text)")

Since I have to delete this table more often with

SQL_DB.ExecNonQuery("DELETE from Hilfsdatei_1")

The problem is the automatic incrementing of the rows_Nr, which does not start again at 1 after the deletion, but continues counting up.
Can you start the lines_not again at 1?

 

[klaus]

Maybe THIS might help.

 

[OliverA]

@Mashiane has a code snippet here (https://www.b4x.com/android/forum/threads/sharing-the-goodness-useful-methods.59058/page-2) that resets the autoincrement to a previous value. Should be no issue to mod it to set the value to 0.

 

[strupp01]

Thanks to both