This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DialognextId is there a way to reset the nextID

I have a requirement to have the sequence number from 1 to 10000 once it reaches 10000    this value NextID should be reset back to 1. I tried using designer process to reset the value it is giving permission denied error.

Is there a way to reset the limit once it reaches the set limit?

Parents
  • The GetNextID() method is transaction-safe. It would be somewhat careless to modify the actual sequence number via a asynchronous process, as it might well increase over your limit before your process runs.I would recommend creating a database trigger to reset the value.

Reply
  • The GetNextID() method is transaction-safe. It would be somewhat careless to modify the actual sequence number via a asynchronous process, as it might well increase over your limit before your process runs.I would recommend creating a database trigger to reset the value.

Children
No Data