Database Column

Auto-Number Database Column - Part

Database Column

Table

From the drop-down list choose the required database table.

Column

From the drop-down list choose the required column.

Valid Characters

Valid

From the drop-down list choose AllAlphaAlphaNumeric or Numeric.

  • Replace invalid characters - enter the required replacement characters
  • Remove invalid characters
  • Error when invalid characters

Start Position

Characters to ignore

Enter the required number of characters to ignore.

 

Auto-Number Database Column - 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.

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 -