Server Administration Application – Configuring Sequences
See also: Server Administration Application Home Page, Working with Sequences
A sequence is used to supply the next number from a defined sequence. It is designed to be used in applications where you need a unique id for a new document e.g. an application form where the sequence provides a unique application id.
Note that sequences do not need to be explicitly created - they are created automatically on the server with default values when they are first used.
Sequences can be created and maintained on the server using the Server Administration web application. They are saved in the server runtime database in table sequences.
See Working with Sequences for information on how to program using sequences.
The meaning of the various columns shown above is explained in the next section.
Sequence properties can be edited when either creating a new sequence using the icon or clicking on the name of an existing sequence.
Name |
The sequence name. This is referred to in scripts that use the sequence. |
Range low value |
The lowest number within the sequence |
Range high value |
The highest possible number within the sequence. When this number is reached attempts to generate a new sequence will generate an error. |
Increment |
The number by which the current id is incremented each time a new sequence is assigned |
Current |
The current high water mark. Change this with care: it may cause duplicate key errors if the sequence is used to create documents with unique keys. |