Release 10.1A: OpenEdge Development:
Progress 4GL Reference

> ## DYNAMIC-CURRENT-VALUE statement

> Resets the current integer value of a sequence defined in the specified database.

> #### Syntax

>     DYNAMIC-CURRENT-VALUE( sequence-exp, logical-dbname-exp ) = expression

> ``sequence-exp``

> A character expression that evaluates to the name of a sequence.

> ``logical-dbname-exp``

> A character expression that evaluates to the name of a connected database in which the sequence is defined.

> ``expression``

> An integer expression assigned as the current value of the specified sequence. If `expression` is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

> #### Notes

> - If `logical-dbname-exp` contains the Unknown value (`?`), Progress generates a runtime error.

> - You cannot set a sequence to the Unknown value (`?`).

> - The user must have CAN-WRITE privileges on the _Sequence table to use the DYNAMIC-CURRENT-VALUE statement.

> - The value of a sequence set by the DYNAMIC-CURRENT-VALUE statement persists in the database until the next DYNAMIC-CURRENT-VALUE statement or DYNAMIC-NEXT-VALUE function is invoked for the sequence, or until the sequence is deleted from the database.

> - You can use any combination of the DYNAMIC-NEXT-VALUE function, DYNAMIC-CURRENT-VALUE function, DYNAMIC-CURRENT-VALUE statement, and their static versions.

> #### See also

> CURRENT-VALUE function, CURRENT-VALUE statement, DYNAMIC-CURRENT-VALUE function, DYNAMIC-NEXT-VALUE function, NEXT-VALUE function

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095