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?