• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 2161 views
  • Users 0 members are here
Options
Related
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

Guru
over 5 years ago

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
  • 0 over 5 years ago

    Hi

    If you try to update DialogNextID.NextNumber via the process component HandleObject.Update it will fail, because an update via the object layer other than the appropriate customizer method is not allowed. But you can update the value by using the SQL component and running the following command line:

    UPDATE DialogNextID SET NextNumber = 1 WHERE Ident_DialogNextID = N'<Enter here the corresponding value of Ident_DialogNextID>'

    -
    Regards
    Sven

Reply
  • 0 over 5 years ago

    Hi

    If you try to update DialogNextID.NextNumber via the process component HandleObject.Update it will fail, because an update via the object layer other than the appropriate customizer method is not allowed. But you can update the value by using the SQL component and running the following command line:

    UPDATE DialogNextID SET NextNumber = 1 WHERE Ident_DialogNextID = N'<Enter here the corresponding value of Ident_DialogNextID>'

    -
    Regards
    Sven

Children
No Data