Reset sequence number

Hi,

Is there a way to reset the sequence number? For example; When the sequence number is greater than 1000 I want to reset it so it starts at 1 again.

Thanks in advance,
Melissa

Hi,

What you could do is remove the sequence and add it again. Then it will restart.
There is no other option to restart a sequence.

Jochem

2 Likes

Hi Melissa,

I have given it a second thought and there is another option. That will be that load another design over the current design. That flushes all your data and also resets your sequence. Be aware that all your data is gone!

1 Like

Hi. I would create a separate number variable that only gets updated once the sequence hits 1000. Then update it with (Sequence - 1000). This would be my new sequence.

2 Likes