Specifications

CHAPTER 8 Displaying and Validating Data
Users Guide 289
Defining validation rules
Typically, you define validation rules in the Database painter, because
validation rules are properties of the data itself. Once defined in the Database
painter, the rules are used by default each time the column is placed in a form.
You can also define a validation rule in the Report painter that overrides the
rule defined in the Database painter.
Defining a validation rule in the Database painter
This section describes the ways you can manipulate validation rules in the
Database painter.
❖ To create a new validation rule
1 In the Extended Attributes view in the Database painter, right-click
Validation Rules and select New from the pop-up menu.
The Validation Rule view displays in the Properties view.
2 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” on page 291.
3 Click the Definition tab and define the expression for the rule.
For information, see “Defining the expression” on page 290.
You can use this rule with any column of the appropriate datatype in the
database.