Understanding validation rules

Validation rules are criteria that a form uses to validate data entered into a column. They are IM-specific and therefore not enforced by the DBMS. Validation rules apply to forms (which support updating) but not to reports.

Validation rules assigned in the Database painter are used by default when you place columns in a form. You can override the default rules in the Report painter.

A validation rule is an expression that evaluates to either “true” or “false”. If the expression evaluates to “true” for an entry into a column, InfoMaker accepts the entry. If the expression evaluates to “false”, the entry is not accepted and an error message is displayed. You can customize the message displayed when a value is rejected.