Incrementing Number

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 NormalUpper case or Lower case.

Number Format

From the drop-down list choose DecimalHexadecimal 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 NoneYearlyMonthlyWeekly 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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

You may like to read -