Auto-Number Incrementing Number - Part
Database Column
This is where you define where to store the last used number.
Table
From the drop-down list choose the required database table.
Column
From the drop-down list choose the required column.
Revert on failure
Switch this option on so that if an operation fails and no other users have generated an incrementing number, the last stored number will be restored.
Initial Value
Initial incrementing number
Enter the required initial number.
Auto-Number Incrementing Number - Options
Constraints
You can optionally configure lengths to constrain the generated value. Leave the lengths at 0 if no constraint is required.
Minimum Length
Enter the required minimum length.
Maximum Length
Enter the required maximum Length
Error when maximum length exceeded
Pad Value
Switch this option on if you want to pad out shorter values up to the minimum length.
Padding Character
Enter the character to use for the padding.
Formatting
Character Case
From the drop-down list choose Normal, Upper case or Lower case.
Number Format
From the drop-down list choose Decimal, Hexadecimal or Alphadecimal. The Alphadecimal format allows you to use the characters 0-9 and A-Z.
Auto-Number Incrementing Number - Auto-Resetting
Auto-Reset Incrementing Number
The incrementing number can be automatically reset periodically.
Auto-Reset
From the drop-down list choose None, Yearly, Monthly, Weekly or Daily.
Database Columns
This is where you define the location to store when the last number was generated.
Date Column
From the drop-down list choose the required column.
Time Column
From the drop-down list choose the required column.