Trigger Execution Order:
1. When the form is opened:
(1) Pre-form
(2) Pre-block (Block level)
(3) When-new-form-instance
(4) When-new-block-instance
(5) When-new-record-instance
(6) When-new-item-instance
2. When you complete one line of records, the cursor moves to the next record:
(1) When-validate-record
(only the records that are filled out are uniquely validated with records that already exist in the database , and they do not error if the data on the page is duplicated and the database does not have a value that duplicates it.)
(2) When-new-record-instance
(3) When-new-item-instance
3. When you click "Save"
(1) When-validate-record
(Submit all the data on the page to the database, if there is duplicate data on the page, the first time the submission succeeds but only the data is written to a similar temporary table in the database, the error occurs when the second duplicate is submitted, the transaction is rolled back, and the original execution of the successful instruction will be revoked.
(2) Pre-insert
(3) On-insert
(4) Post-insert
(5) Post-forms-commit
(6) Pre-block (Block level)
(7) Key-commit
(8) When-new-item-instance
4. When the cursor is moved to a row already displayed in the current block of data:
(1) When-remove-record
(2) When-new-record-instance
(3) When-new-item-instance
When the different item on the line is moved:
(4) When-new-item-instance
5. When you want to make a modification (when you make a modification to an item in the record):
(1) On-lock
6. When you save after the modification is complete:
(1) When-validate-record
(2) Pre-update
(3) On-update
(4) Post-forms-commit
(5) Pre-block (Block level)
(6) Key-commit
(7) When-new-item-instance
7. When you delete a record:
(1) On-lock
(2) When-remove-record
(3) Key-delrec
(4) When-new-record-instance
(5) When-new-item-instance
8. F11 Query process:
(1) When-clear-block
(2) When-new-record-instance
(3) When-new-item-instance
After entering the query criteria, point ctrl+f11:
(4) Pre-query
(5) When-clear-block
(6) Post-query
(7) When-new-record-instance
(8) When-new-item-instance
9. CRRL+F11:
(1) When-clear-block
(2) Pre-query
(3) When-clear-block
(4) Post-query (one record per check, trigger once)
(5) When-new-record-instance
(6) When-new-item-instance
10.