Kbase 16706: Must use CURRENT-VALUE to reset a sequence after ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Must use CURRENT-VALUE to reset a sequence after ?
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. 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.
Progress Software Technical Support Note # 16706