oracle_form_常用Trigger的触发时机-执行顺序

《oracle_form_常用Trigger的触发时机-执行顺序》由会员分享，可在线阅读，更多相关《oracle_form_常用Trigger的触发时机-执行顺序（7页珍藏版）》请在装配图网上搜索。

1、常用Trigger的触发时机 Form Level:PRE-FORM启动Form,第一个Block初始化前WHEN-NEW-FORM-INSTANCEPRE-xxx初始化结束后，焦点导航到Form时POST-FORM焦点离开Form时POST-DATABASE-COMMITForm上有数据库数据变化要提交时WHEN-TAB-PAGE-CHANGED当Form上有Tab Canvas，Tab Page变化时触发KEY-EXIT退出Form.WHEN-WINDOW-CLOSED点击Window右上角close图示.如果通过F4关闭则不会触发这个triggerCLOSE-WINDOW点击 Windo

2、w 右上角 close 图示,After WHEN-WINDOW-CLOSE Block Level:Trigger触发时机PRE-BLOCKBLOCK得到焦点，初始化之前PRE-RECORDRecord 初始化前.After PRE-BLOCK, Before WHEN-NEW-BLOCK-INSTANCEWHEN-NEW-BLOCK-INSTANCEBlock获得焦点时触发WHEN-NEW-RECORD-INSTANCERecord 获得焦点时触发.After WHEN-NEW-BLOCK-INSTANCEWHEN-VALIDATE-RECORDRecord 中的 item validat

3、e 通过后，block commit 前触发POST-RECORD焦点离开Record触发POST-BLOCK焦点离开 Block 触发.After POST-RECORDPRE-INSERTInsert操作确认后commit前触发PRE-UPDATEUpdate操作确认后commit前触发PRE-DELETEDelete操作确认后commit前触发ON-INSERTInsert操作写入DB时触发ON-UPDATEUpdate操作写入DB时触发ON-DELETEDelete操作写入DB时触发ON-LOCK从DB中查询出的record,在第一个发生值变化的操作时触发，lock之后其它的值变化 操

4、作不会再触发；直到commit后自动解除lockPRE-QUERY在执行SQL前触发。可以用来设置数据块default_where, order_by等属性POST-QUERY执行SQL后，将查询的数据集提取到窗体记录各项之前触发Item Level:PRE-TEXT-ITEMTextItemTextItem 初始化前，在 WHEN-NEW-ITEM-INSTANCE 之前触发。隐藏的text item没有这个triggerWHEN-NEW-ITEM-INSTANCEAll可见Item得到焦点时触发注意：不在Canvas上显示的object item是没有这个trigger的POST-CHAN

5、GEItem如果Item状态或值有变化，在焦点离开item时触发WHEN-VALIDATE-ITEM所有可编辑的Item有变化的item焦点移开时，在POST-CHANGE trigger之后触发POST-TEXT-ITEMTextItemValidate item之后触发KEY-LISTVALTextItem有LOV的TextItem选择value时触发WHEN-LIST-CHANGEDLIST下拉列表选项变化时触发WHEN-RADIO-CHANGEDRadio GroupRadio group的选中radio button项变化时触发WHEN-BUTTON-PRESSEDBUTTONBut

6、ton点击或确定时触发常见的Trigger触发顺序ActionSequenceTriggerLevelOpen Form（当打开FORM 时）1PRE-FORMForm2PRE-BLOCKBlock3PRE-RECORDBlock4PRE-TEXT-ITEMItem5WHEN-NEW-FORM-INSTANCEForm6WHEN-NEW-BLOCK-INSTANCEBlock7WHEN-NEW-RECORD-INSTANCEBlock8WHEN-NEW-ITEM-INSTANCEItemPage Down/Up（查询出记录后翻页到前/后记录）1POST-RECORDBlock2POST-BLO

7、CKBlock3PRE-BLOCKBlock4PRE-RECORDBlock5WHEN-NEW-RECORD-INSTANCEBlock6WHEN-NEW-ITEM-INSTANCEItemInsert Record1POST-CHANGEItemCommit db 前准备，验证资料。2WHEN-VALIDATE-ITEMItem3POST-TEXT-ITEMItem4WHEN-VALIDATE-RECORDBlock5POST-RECORDBlock6POST-BLOCKBlockUpdateRecord7PRE-COMMITFormInsert 到 DB 中8PRE-INSERTBlock

8、9ON-INSERTBlock10POST-INSERTBlock11POST-FORMS-COMMITForm12ON-COMMITForm13POST-DATABASE-COMMITForm14PRE- BLOCKBlock从DB中取record 到 block中15PRE- RECORDBlock16PRE-TEXT-ITEMItem17WHEN-NEW-ITEM-INSTANCEItem1POST-CHANGEItem在每个需要commit 的item 和 block 上触发.commit前的准备.2WHEN-VALIDATE-ITEMItem3POST-TEXT-ITEMItem4W

9、HEN-VALIDATE-RECORDBlock5POST-RECORDBlock6POST-BLOCKBlock7PRE-COMMITFormStep 6-8循环在 每个block上触 发。到 step 9 database 中数 据 updated8PRE-UPDATEBlock9ON-UPDATEBlock10POST-UPDATEBlock11POST-FORMS-COMMITForm12ON-COMMITForm13POST-DATABASE-COMMITForm14PRE- BLOCKBlock保存完毕重新load record15PRE- RECORDBlock16PRE-TEX

10、T-ITEMItem17WHEN-NEW-ITEM-INSTANCEItem1POST-RECORDBlockForm上输入框变成蓝底色的查询模式2WHEN-CLEAR-BLOCKBlock3WHEN-NEW-RECORD-INSTANCEBlock4PRE-QUERYBlock查询并返回data5PRE-SELECTBlock6ON-SELECTBlock7POST-SELECTBlock8POST-QUERYBlock9WHEN-NEW-RECORD-INSTANCE显示dataEnter Query触发器执行顺序:1 .当打开FORM时：(1) PRE-FORM(2) PRE-BLOCK

11、 (BLOCK 级)(3) WHEN-NEW-FORM-INSTANCE(4) WHEN-NEW-BLOCK-INSTANCE(5) WHEN-NEW-RECORD-INSTANCE(6) WHEN-NEW-ITEM-INSTANCE2. 当填写一行记录完成后，光标移动到下一条记录的时候：(1) WHEN-VALIDATE-RECORD(只将填写的记录与数据库中已存在的记录作唯一性的验证，如果只是页面上的数据重复而数据库中没有与其重复的值则 不会报错.)(2) WHEN-NEW-RECORD-INSTANCE(3) WHEN-NEW-ITEM-INSTANCE3. 当点击“保存”时(1) WH

12、EN-VALIDATE-RECORD(将页面上的所有数据提交到数据库，若页面上有重复的数据，则提交第一次时成功但只是将数据先写到数据库中一类 似临时表的地方，在提交第二条重复记录的时候报错，执行事务回滚，原来执行成功的指令也将被撤消)(2) PRE-INSERT(3) ON-INSERT(4) POST-INSERT(5) POST-FORMS-COMMIT(6) PRE-BLOCK (BLOCK 级)(7) KEY-COMMIT(8) WHEN-NEW-ITEM-INSTANCE4. 当光标移动到当前数据块中已经显示的行上时：(1) WHEN-REMOVE-RECORD(2) WHEN-NE

13、W-RECORD-INSTANCE(3) WHEN-NEW-ITEM-INSTANCE当在该行上的不同ITEM移动时：(4) WHEN-NEW-ITEM-INSTANCE5. 当要进行修改时(在记录中的某个项上进行了修改时)：(1) ON-LOCK6. 在修改完成后进行保存时：(1) WHEN-VALIDATE-RECORD(2) PRE-UPDATE(3) ON-UPDATE(4) POST-FORMS-COMMIT(5) PRE-BLOCK (BLOCK 级)(6) KEY-COMMIT(7) WHEN-NEW-ITEM-INSTANCE7. 删除一条记录时：(1) ON-LOCK(2)

14、WHEN-REMOVE-RECORD(3) KEY-DELREC(4) WHEN-NEW-RECORD-INSTANCE(5) WHEN-NEW-ITEM-INSTANCE8. F11查询过程：(1) WHEN-CLEAR-BLOCK(2) WHEN-NEW-RECORD-INSTANCE(3) WHEN-NEW-ITEM-INSTANCE在输入查询条件后点CTRL+F11 ：(4) PRE-QUERY(5) WHEN-CLEAR-BLOCK(6) POST-QUERY(7) WHEN-NEW-RECORD-INSTANCE(8) WHEN-NEW-ITEM-INSTANCE9. CRRL+F

15、11：(1) WHEN-CLEAR-BLOCK(2) PRE-QUERY(3) WHEN-CLEAR-BLOCK(4) POST-QUERY (每查一条记录，触发一次)(5) WHEN-NEW-RECORD-INSTANCE(6) WHEN-NEW-ITEM-INSTANCE10. 从查询状态(F11)转为输入状态(F4)时：(1) WHEN-CLEAR-BLOCK(2) KEY-EXIT(3) WHEN-NEW-RECORD-INSTANCE(4) WHEN-NEW-ITEM-INSTANCE11 .手电筒查询过程：(1) QUERY_FIND (BLOCK 级)输入查询条件后，点击“查询”

16、按钮：(2) WHEN-CLEAR-BLOCK(3) PRE-QUERY(4) WHEN-CLEAR-BLOCK(5) POST-QUERY(6) WHEN-NEW-RECORD-INSTANCE(7) WHEN-NEW-ITEM-INSTANCE12. 点击“New ”时：(1) WHEN-NEW-RECORD-INSTANCE(2) WHEN-NEW-ITEM-INSTANCE13. 点击 “EditField” 时：(1) KEY-EDIT14. 点击 “WindowHelp” 时：(1) KEY-HELP15. 点击 “ClearRecord” 时：(1) WHEN-REMOVE-RE

17、CORD(2) POST-QUERY(3) WHEN-NEW-RECORD-INSTANCE(4) WHEN-NEW-ITEM-INSTANCE16. 点击F4关闭时：(1) KEY-EXIT(2) POST-FORM17. 点击“CloseForm”按钮关闭时：(1) KEY-EXIT(2) POST-FORM18. 点击 “Translations” 按钮时：(1) TRANSLATIONS19. 点击小叉号关闭时：(1) WHEN-WINDOW-CLOSED(2) CLOSE-WINDOW(3) KEY-EXIT(4) POST-FORM20. 选中LOV列表：(1) KEY-LISTVAL(2) WHEN-NEW-ITEM-INSTANCE21 .选中记录前面的小条时：(1) WHEN-NEW-RECORD-INSTANCE(2) WHEN-NEW-ITEM-INSTANCE (数据项级)(3) WHEN-NEW-ITEM-INSTANCE22.光标上下移动时：(1) WHEN-NEW-RECORD-INSTANCE(2) WHEN-NEW-ITEM-INSTANCE