This section describes the ways you can manipulate validation rules in the Database painter.
To create a new validation rule
In the Database painter, select Object>Insert>Validation Rule from the menu bar.
The Validation Rule view displays in the Properties view.
Assign a name to the rule, select the datatype of the columns to which it applies, and customize the error message (if desired).
For information, see “Customizing the error message”.
Click the Definition tab and define the expression for the rule.
For information, see “Defining the expression”.
You can use this rule with any column of the appropriate datatype in the database.
To modify a validation rule:
In the Database painter, open the Extended Attributes view.
In the Extended Attributes view, open the list of validation rules.
Position the pointer on the validation rule you want to modify, display the pop-up menu, and select Properties.
In the Validation Rule view, modify the validation rule as desired.
For information, see “Defining the expression” and “Customizing the error message”.
To associate a validation rule with a column in
the Database painter:
In the Database painter (Objects view), position the pointer on the column, select Properties from the column’s pop-up menu, and select the Validation tab.
Select a validation rule from the Validation Rule drop-down list.
The column now has the selected validation rule associated with it in the extended attribute system tables. Whenever you use this column in a DataWindow object, it will use this validation rule unless you override it in the DataWindow painter.
To remove a validation rule from a column in the
Database painter:
In the Database painter (Objects view), position the pointer on the column, select Properties from its pop-up menu, and select the Validation tab in the Properties view.
Select (None) from the list in the Validation Rule drop-down list.
The validation rule is no longer associated with the column.
