How to Reset Auto Increment Field of Table?

coblongpamor · 2012-04-06 05:49:26

i found this on SO to reset AUTO_INCREMENT field in SQLite Database.

DELETE FROM MyTableName
DELETE FROM SQLITE_SEQUENCE WHERE NAME = 'MyTableName'

is it posible to do this with framework without engineexecute?

thank you.

ab · 2012-04-06 06:50:09

This is a very dedicated process.
There is no such ORM method in the framework by now.

You'd better run this on the Server side, with EngineExecute().

coblongpamor · 2012-04-06 08:15:38

ok, thank you.

mORMot Open Source