mORMot Open Source

tech

Member

Registered: 2014-01-13

Posts: 110

Reset ID after 'DELETE FROM TABLE'

Hi,
Is it possible to reset the ID after this ?

globalClient.EngineExecute('delete from table');

The table is temporary and I want to start new IDs after a delete.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Reset ID after 'DELETE FROM TABLE'

I've added TSQLRestServerStaticExternal.ResetMaxIDCache method.
See http://synopse.info/fossil/info/fe496091db

tech

Member

Registered: 2014-01-13

Posts: 110

Re: Reset ID after 'DELETE FROM TABLE'

This is great.
Thnx,