Specifications

Defining validation rules
290 InfoMaker
❖ To modify a validation rule:
1 In the Database painter, open the Extended Attributes view.
2 In the Extended Attributes view, open the list of validation rules.
3 Double-click the validation rule you want to modify.
4 In the Validation Rule view, modify the validation rule as desired.
For information, see “Defining the expression” on page 290 and
“Customizing the error message” on page 291.
❖ To associate a validation rule with a column in the Database painter:
1 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.
2 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 form,
it will use this validation rule unless you override it in the Form painter.
❖ To remove a validation rule from a column in the Database painter:
1 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.
2 Select (None) from the list in the Validation Rule drop-down list.
The validation rule is no longer associated with the column.
Defining the expression
A validation rule is a boolean expression. InfoMaker applies the boolean
expression to an entered value. If the expression returns “true”, the value is
accepted. Otherwise, the value is not accepted and an error message displays.
What expressions can
contain
You can use any valid InfoMaker expression in validation rules.
Validation rules can include most InfoMaker expression functions. InfoMaker
expression functions are displayed in the Functions list and can be pasted into
the definition.
For information about these functions, see Chapter 24, “DataWindow
Expression and InfoMaker Functions.”