The Rules Engine - Rules Engine Behavior - Domain Checks

Previous Next

In a USoft application window, domain checks are performed when the user has entered a field value and leaves the field.

If a record is manipulated in the SQL Command dialog, or in a non-USoft application that connects to the USoft Rules Engine via ODBC, domain checks are performed at record validation time.

Domain checks are:

The value must correspond to the data type.

The value must not exceed the maximum column width. If the length of a string value exceeds the maximum column width, the value is truncated to the maximum column width.

Must the value be uppercase?

The value must be within the range of the minimum and maximum value. (not for DATE fields)

For NUMBER values, the number of decimals must be correct.

For NUMBER values, the number of digits before the period must be correct.

The value must match the IO Format.

Must the value have a fixed length?

Are there any allowed values defined?