Release 10.1A: OpenEdge Development:
Progress 4GL Reference

> ## DYNAMIC-CURRENT-VALUE function

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

> #### Syntax

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

> ``sequence-expression``

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

> ``logical-dbname-expression``

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

> #### Notes

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

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

> - The current value of a sequence can be one of the following:

> - The initial value specified in the Data Dictionary.
> - The last value set with either the DYNAMIC-CURRENT-VALUE statement or the DYNAMIC-NEXT-VALUE function.
> - The Unknown value (`?`) if the sequence has exceeded its minimum or maximum and is not cycling.
> - Sequence values are stored in the database in which they are defined, and persist between each invocation of the DYNAMIC-CURRENT-VALUE statement or DYNAMIC-NEXT-VALUE function.

> - You cannot invoke the DYNAMIC-CURRENT-VALUE function from within a WHERE clause. Doing so generates a compiler error. To use a result from the DYNAMIC-CURRENT-VALUE function in a WHERE clause, assign the result to a variable, then use the variable in the WHERE clause.

> - 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 statement, DYNAMIC-NEXT-VALUE function, NEXT-VALUE function

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