Skip to content

Create New Validation Object

Use this dialog to create a new validation object in the current data dictionary class package (.DD file).

Object Name

Enter a name for the new validation object.

Type

Select the validation object type. This determines the object's class and, consequently, its behavior. Choose between:

  • Validation Table (1-column): Selects the ValidationTable class. This class maintains a simple list of validation values.
  • Description Validation Table (2-columns): Selects the DescriptionValidationTable class. This class maintains a list of validation value and description pairs.
  • Code Validation Table (database): Selects the CodeValidationTable class. This class accesses a database table (CodeMast) to provide validation value and description pairs.

For more information about the different types of validation objects, see the section on Using Validation Tables.

Type Value

When you select the Code Validation Table type (above), you are required to select a Type Value. The Type Value is used to choose the subset of records from the CodeMast table that will populate the validation value and description pairs.

The combo list is populated with existing Type Values from the CodeMast table. Enter the desired Type Value or select one from the combo list.

You can change the Type Value at any time within the Data Dictionary Modeler.

Apply to Column

A table column must reference a validation object in order for it to perform data-entry validation. Select one or more columns from the data dictionary's table that will use this validation object. Data Dictionary Modeler will generate the necessary code to reference the validation object for each selected column.

You can add new references to the object or remove references from the Data Dictionary Modeler's Columns Tab by activating the Validation Objects dialog.

OK

Click OK to create the new validation object and any column references you selected. The dialog is closed, and the new object is added to the Validation Objects list.

Cancel

Click Cancel to close the dialog without creating a new validation object.

See Also