Rules Engine behaviour on INSERT

Here is an overview of all actions and checks that are performed when a record is inserted. These actions and checks fall into validation moments:

•Field validation before insert.

•Group validation before insert.

•Pre-store record validation before insert.

•Post-store record validation after insert.

•Transaction validation after insert.

Field validation and group validation do not take place if manipulations are executed in the SQL Command dialog or by using the SqlScript() method. They also do not take place if the record is inserted in a non-USoft application that connects to the USoft Rules Engine via ODBC.

NOTE: Appendix A, "Rules Engine Checks", gives a summary of all checks the Rules Engine performs for inserts, updates and deletes.