| title | description | ms.author | ms.date | ms.topic | author | ms.reviewer |
|---|---|---|---|---|---|---|
NumberSequence Data Type |
Is a complex data type for creating and managing number sequences in the database. |
solsen |
05/14/2024 |
reference |
SusanneWindfeldPedersen |
solsen |
Version: Available or changed with runtime version 4.0.
Is a complex data type for creating and managing number sequences in the database.
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. |
Using number sequences
Get atarted with AL
Developing extensions