Validation Codes Maintenance
Use this dialog to edit the current workspace's validation codes database.
Each workspace contains two system tables called CodeMast and CodeType. These tables are used to store collections of validation codes (value and description pairs). Validation codes are used by CodeValidationTable objects in your data dictionaries to validate column data.
Each validation code collection is 'typed' by assigning a Type Value. When a Type Value is applied to a CodeValidationTable object, the set of validation codes used to validate the column data is constrained to that type.
Data Entry
Type Values
Enter a type value string for each validation code collection you wish to define. The type code string should be a short description of the validation code collection (up to 10 characters).
Example: For a collection of state name validation codes, you might use "STATES" as the Type Value.
To create a new Type Value, simply navigate to the bottom of the Type Values list or click the Add button on the toolbar.
Type Description
Enter a longer description for the currently selected Type Value (up to 30 characters). This provides internal documentation to help identify each validation code collection.
Code Value & Description Grid
Use this grid to add, delete, and edit code and description pairs for the currently selected Type Value. The codes will be the values that are used to validate a table column's data. The descriptions will provide more information to the user when they are choosing a code value from a pick list while entering data into the column.
To add a new code and description pair, simply navigate to the last row of the grid.
Each time you navigate to a different grid row, any changes to the row you are exiting will be automatically saved.
Close
Click the Close button to close the dialog. If there are any unsaved changes to the validation codes database, you will be prompted whether you wish to continue.
Toolbar
Add
Click the Add button to create a new Type Value in the Type Values list.
Keyboard shortcut: (F5)
Save
Click the Save button to save changes to the Type Value you are currently editing. Note that you normally do not need to use the save button, as changes are saved to the database simply by navigating from one validation code to another.
Keyboard shortcut: (F2)
Delete
Click the Delete button to delete either the selected Type Value or a single Code and Description pair within the selected Type Value.
- To delete an entire Type Value, select it in the Type Values list, then click Delete. Deleting a Type Value also removes each associated Code and Description pair from the database.
- To delete an individual Code and Description pair, select it in the Code and Description grid control, then click Delete.
Keyboard shortcut: (Shift+F2)