#1 2012-04-06 05:49:26

coblongpamor
Member
From: Bali-Indonesia
Registered: 2010-11-07
Posts: 130
Website

How to Reset Auto Increment Field of Table?

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.

Offline

#2 2012-04-06 06:50:09

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,274
Website

Re: How to Reset Auto Increment Field of Table?

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().

Offline

#3 2012-04-06 08:15:38

coblongpamor
Member
From: Bali-Indonesia
Registered: 2010-11-07
Posts: 130
Website

Re: How to Reset Auto Increment Field of Table?

ok, thank you.

Offline

Board footer

Powered by FluxBB