ORACLE Formbuilder Trigger Execution order

1. When you open the form:

(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-instance2. When a row of records is completed, the cursor moves to the next record: (1) When-validate-record (only the records that are filled in with the records that exist in the database are uniquely verified, if only the data on the page is duplicated and there are no duplicate values in the database, there is no error.) (2) When-new-record-instance (3) when-new-item-instance3. When you click on "Save" (1) When-validate-record (all the data on the page is submitted to the database, if there is duplicate data on the page, the first time the submission succeeds but only writes the data to the database in a similar temporary table, when the second duplicate record is submitted to the error, Perform a transaction rollback, The original execution of a successful instruction will also 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-it Em-instance4. When the cursor moves over the line that is already displayed in the current data block: (1) When-remove-record (2) when-new-record-instance (3) when-new-item-instance when the different ITEM on the line moves: (4) When-new -item-instance5. When you want to make a modification (modified on an item in the record): (1) on-lock6. When the modification is complete, Save: (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-instance7. When deleting a record: (1) on-lock (2) When-remove-record (3) Key-delrec (4) when-new-record-instance (5) When-new-item-instance8. F11 query process: (1) when-clear-block (2) WHEN-new-record-instance (3) when-new-item-instance after you enter the query criteria, click CTRL + F11: (4) Pre-query (5) When-clear-block (6) post-query (7) when-new-record-instance (8) When-new-item-instance9. CRRL+F11: (1) when-clear-block (2) pre-query (3) When-clear-block (4) post-query (each record is checked, Trigger once) (5) when-new-record-instance (6) When-new-item-instance10. From the query state (F11) to the input state (F4): (1) when-clear-block (2) key-exit (3) when-new-record-instance (4) When-new-item-instance11. Flashlight Query process: (1) query_find (block level) after entering the query criteria, click "Query" Button: (2) When-clear-block (3) pre-query (4) When-clear-block (5) post-query (6) when-new-record-instance (7) WHEN-NEW-ITEM-INSTANCE12 ． When you click "New": (1) when-new-record-instance (2) when-new-item-instance13. When you click "EditField": (1) key-edit14. When you click "Windowhelp": (1) key-help15. When you click "Clearrecord": (1) When-remove-record (2) post-query (3) when-new-record-instance (4) When-new-item-instance16. Click F4 when closed: (1) key-exit (2) post-form17. When you click the "Closeform" button to close: (1) key-exit (2) post-form18. When you click on the "Translations" button: (1) TRANSLATIONS19. When you click the Small Fork, close: (1) when-window-closed (2) Close-window (3) key-exit (4) post-form20. Check the Lov list: (1) Key-listval (2) when-new-item-instance21. When the previous strip is checked: (1) when-new-record-instance (2) When-new-item-instance (data item level) (3) When-new-item-instance22. When the cursor moves up or down: (1) when-new-record-instance (2) when-new-item-instance

ORACLE Formbuilder Trigger Execution order