Kbase P125392: What happens to a sequence when the sequence limit value is the unknown value and that value is reac
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/08/2007 |
|
Status: Unverified
GOAL:
What happens to a sequence when the sequence limit value is the unknown value and that value is reached?
FACT(s) (Environment):
Progress 6.x
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
If for any reason, a sequence value becomes unknown (?), you must use the CURRENT-VALUE statement to reset it. NEXT-VALUE will continue to return unknown until the CURRENT-VALUE is reset. A sequence value might become unknown (?) when any modification is made to the sequence properties through the data dictionary or when the sequence has cycled to its defined limit and that defined limit is the unknown value. If sequences are being used to ensure uniqueness of a key, this can allow duplicates of even a unique key, since duplicates of the unknown value are allowed unless the field is mandatory.