Collapse AllExpand All

12.3. Serial Columns

When data is imported into database tables, it is possible to overlook or disrupt the auto-numbering sequence for a particular table. The Serial Columns utility was designed to identify and correct problems caused by this scenario. Because this screen will be of little value to most users, access to this screen is limited to admin users only. To identify and correct sequence problems, select the "Serial Columns" option. The following screen will appear:

Fix Serial Columns

When identifying and correcting sequence problems, you are presented with the following options:

Only Show Problems

Select to include only tables which have sequencing problems in the display. No problems will exist as long as the "Next Key" value is equal to or greater than the "Largest Key Used" value. A problem exists if the "Largest Key Used" value is greater than the "Next Key" value.

Tables

Display lists the complete set of database tables and corresponding sequences. If the "Only Show Problems" option is selected, then only those tables which have sequence problems will be included in the display.

The following buttons are unique to this screen:

FIX ALL

Select to fix all the sequence problems in all the tables.

FIX

Highlight a table and then select this option to fix only the highlighted sequence problem.