...
Autoincrement settings are stored in thetwo tables:
- The Number (sys_number)
...
- table contains the Maximum digits and the Prefix settings for the table;
- The Autoincrement (sys_number_autoincrement) table stores the autoincrement setting related to the table.
| Tip |
|---|
For working correctly, records in both tables must be created. If the record in the Number (sys_number) table exists and the record in the Autoincrement (sys_number_autoincrement) table is not, then it will be created automatically, and the numbering will start with 1, |
To create an autoincrement rule, the following criteria must be met: the object you are configuring autoincrement for must have a field that should be incremented. It must have a String type, and generally, these fields are named as "Number".
...