Server Administration Application – Configuring Sequences

Documentation home

 

See also: Server Administration Application Home Page, Working with Sequences

 

Introduction. 1

Configuring Sequences 1

Sequence Properties 2

 

Introduction

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.

 

Configuring Sequences

 

 

 

The meaning of the various columns shown above is explained in the next section.

 

Sequence Properties

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.