Filter
Top Products
CHAPTER 8 Displaying and Validating Data
DataWindow Designer User’s Guide 257
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
DataWindow object. You can also define a validation rule in the DataWindow
object 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 Database painter, select Object>Insert>Validation Rule from the
menu bar.
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 260.
3 Click the Definition tab and define the expression for the rule.
For information, see “Defining the expression” on page 258.
You can use this rule with any column of the appropriate datatype in the
database.