AnsweredAssumed Answered

Script to reset primary key Next Value number?

Question asked by MikeF on Dec 17, 2011
Latest reply on Dec 17, 2011 by Sorbsbuster

Title

Script to reset primary key Next Value number?

Post

 

Is there a script that will reset the Primary Key in a table?

Example ...

Have a delete button on a layout, which will delete an unused record from its source table.  Once that's done, would like a script that looks at the maximum __kp_MyPrimaryKeyField number and adds 1 to its Serial Number | Next Value in the Auto Enter section.

Can this be done?

Thanks,

  Mike

Outcomes