Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
It can be used for various purposes. One of them, such as for example, is registering tasks for further processing and statistical purposes.
Autoincrement The autoincrement settings are stored in the Number (sys_number) table that contains the Maximum digits, the Prefix,and the Start Value settings for tables.
In order to To create an autoincrement, the following criteria must be met:
- The object for which you are configuring an autoincrement , must have a field that should be incremented.
- The field should be of String type. These fields are usually named Number.
If your table does not have this field, you can create it. Refer to the Create a ColumnColumns article for more information.
Number form fields
Field | Mandatory | Description |
|---|---|---|
| Prefix | Y | Specify at least three Latin letters that will be added at the beginning of every record number in this table. |
| Maximum digits | Y | Define the maximum number of digits after the prefix. |
| Start Value | Y | Specify the initial value of the sequence. The default value is ' 1'. |
Example
| Info | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
You just created the a sequence, and you filled in the fields in the following way:
So In this case, the first record number will be ABC000022, and the numbers of the subsequent records will be ABC000023, ABC000024, and so on. |
If the value of the Start Value changes, and it is greater than the current value of the sequence, the previous sequence will be saved, and the new sequence will be set to a new starting value.
| Note |
|---|
|