• Registered: 2022-08-03
  • Posts: 89

Topic: Faire revenir Id a 0

Bonjour a Tous

J'ai besoin de votre aide

Apres avoir effacé le contenu d'une base je voudrai faire revenir  Id a 0.

Avant de commencer a saisir des nouveaux éléments.

Merci de votre aide

Niko

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: Faire revenir Id a 0

Hi,
I'm guessing that you mean that you want to delete the contents of a table rather than the database (if you delete the entire database, all the IDs in the new database will start at 0 anyway).
If so, then after you have deleted the contents of your table, add this to your code;

sqlexecute('delete from sqlite_sequence where name = "mytablename"');

If, however, you DO want to delete the entire database, I would do it using a batch file that runs when your program closes.
Not sure why you need to do either?
Derek.

3 Reply by sparrow (edited by sparrow 2022-09-26 15:41:05)

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 894

Re: Faire revenir Id a 0

Hi Nikomax, hi Derek


OR


UPDATE SQLITE_SEQUENCE SET SEQ=0 WHERE NAME='table_name';
  • Registered: 2022-08-03
  • Posts: 89

Re: Faire revenir Id a 0

Bonjour Derek Bonjour moineau

Merci de votre aide, j'ai compris la différence des deux.

Niko