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.

Sequences can be created and maintained on the server using the Server Administration web application. They are saved in the Ebase Xi runtime database in table sequences. 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.

See Working with Sequences for information on how to program using sequences.

Configuring Sequences

• Click the icon to create a new sequence
• Click the icon to refresh the display
• Click the icon to delete a sequence
• Click on a sequence name to display or edit its properties
• Click Help on the menu at the top of the panel to display this help page

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.