Question about Sequence

[Rabbit]

I have a new sequence with initial value 1 during creation. After I change the initial value to 80000, but when I use the next-value() command to get the next value from this sequence, the return is 1 instead of 80000.

Is it becuase I have to re-compile the get sequence program after I update the sequence or anyother reason? Please advice, thank you!

 

[MurrayH]

You could try

current-value(seq) = 80000

then say

disp next-value(seq)

and see what happens. Do you have more than one database? If so you may have the same sequence defined in 2 DBs.

Murray