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?
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?