NumberSequence Data Type

Version: Available or changed with runtime version 4.0.

Is a complex data type for creating and managing number sequences in the database.

Static methods

The following methods are available on the NumberSequence data type.

Method name Description
Current(Text [, Boolean]) Gets the current value from the number sequence, without doing any increment. The value is retrieved out of transaction. The value will not be returned on transaction rollback.
Delete(Text [, Boolean]) Deletes a specific number sequence.
Exists(Text [, Boolean]) Checks whether a specific number sequence exists.
Insert(Text [, BigInteger] [, BigInteger] [, Boolean]) Creates a number sequence in the database, with the given parameters.
Next(Text [, Boolean]) Retrieves the next value from the number sequence.
Range(Text, Integer [, Boolean]) Retrieves a range of values from the number sequence.
Range(Text, Integer, var BigInteger [, Boolean]) Retrieves a range of values from the number sequence.
Restart(Text [, BigInteger] [, Boolean]) Restarts a number sequence.

See Also

Using number sequences
Get atarted with AL
Developing extensions