jeudi 22 octobre 2015

SQL insert into command after deleting a row

I have a project on c# sqlite. I delete a row in a table from my database (with " delete" command) . It deletes fine. After deletion when I try to add a new row (with insert to). It adds new row to deleted rows index but other inserts added to end of table.

Example: I have 10 rows. I deleted 4th row. I want to add a new row . when I add, It adds new row between 3th and 5th row. but other inserts are added to end of table. I want add all data to and of table. Can you help me ?

Aucun commentaire:

Enregistrer un commentaire