Field Validation Before Insert

Previous Next

In a USoft application window, when the user enters a field value in a new record, or clicks the New Record button:

For all columns based on a domain with a default value, this value is set.

For all columns with a default value, this value is set.

If a default value is specified on domain and column level, the default value for the column is set.

When the user has entered a field value and leaves the field:

1.Checks on domain level are performed.
2.Corrective domain constraints are evaluated.
3.Restrictive domain constraints are evaluated.

If a domain has a superdomain, the constraints on the superdomain are evaluated first, then the constraints on the domain itself. Within the domain, all checks are performed according to the Position in Checking Order attribute, set when defining the domain constraint.