Reset ORMID

General Questions/Discussions
1

Hello

Is there any way to reset ORMID for any record in SQL database set by DB-VA after deleting some records. For example I created records

Record1
Record2
Record3
Record4

And their ORMIDs are 1, 2, 3, 4. Then when I delete Record4 form the database, next record will be created with
ORMID=5 regardless to erased previos record with ORMID=4, is there any method for ORMID recalculation after some records deleting.

Thanks

2

Hi zilot,

I am afraid the built-in ID generator cannot fulfill your need. I suggest you achieve your need by using ID generator. Attached is a document that talks about it.

Hope this helps. Feel free to let me know if there are any questions.

Best regards,
Jick
Customizing ID Generator.pdf

3

Thank you for the replay

4

Hi zilot,

You’re welcome. Should you need any other helps, feel free to post again! :slight_smile: :slight_smile:

Best regards,
Jick