Oracle Form 触发器执行顺序

Oracle Form 触发器执行顺序(转)



触发器执行顺序:


1.当打开FORM时:


(1)PRE-FORM


(2)PRE-BLOCK(BLOCK级)


(3)WHEN-NEW-FORM-INSTANCE


(4)WHEN-NEW-BLOCK-INSTANCE


(5)WHEN-NEW-RECORD-INSTANCE


(6)WHEN-NEW-ITEM-INSTANCE


2.当填写一行记录完成后,光标移动到下一条记录的时候:


(1)WHEN-VALIDATE-RECORD
(只将填写的记录与数据库中已存在的记录作唯一性的验证,如果只是页面上的数据重复而数据库中没有与其重复的值则不会报错.)


(2)WHEN-NEW-RECORD-INSTANCE


(3)WHEN-NEW-ITEM-INSTANCE


3.当点击“保存”时


(1)WHEN-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-INSTANCE


4.当光标移动到当前数据块中已经显示的行上时:


(1)WHEN-REMOVE-RECORD


(2)WHEN-NEW-RECORD-INSTANCE


(3)WHEN-NEW-ITEM-INSTANCE


当在该行上的不同ITEM移动时:


(4)WHEN-NEW-ITEM-INSTANCE


5.当要进行修改时(在记录中的某个项上进行了修改时):


(1)ON-LOCK


6.在修改完成后进行保存时:


(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-INSTANCE


7.删除一条记录时:


(1)ON-LOCK


(2)WHEN-REMOVE-RECORD


(3)KEY-DELREC


(4)WHEN-NEW-RECORD-INSTANCE


(5)WHEN-NEW-ITEM-INSTANCE


8.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-INSTANCE


9.CRRL+F11:


(1)WHEN-CLEAR-BLOCK


(2)PRE-QUERY


(3)WHEN-CLEAR-BLOCK


(4)POST-QUERY(每查一条记录,触发一次)


(5)WHEN-NEW-RECORD-INSTANCE


(6)WHEN-NEW-ITEM-INSTANCE


10.从查询状态(F11)转为输入状态(F4)时:


(1)WHEN-CLEAR-BLOCK


(2)KEY-EXIT


(3)WHEN-NEW-RECORD-INSTANCE


(4)WHEN-NEW-ITEM-INSTANCE


11.手电筒查询过程:


(1)QUERY_FIND(BLOCK级)


输入查询条件后,点击“查询”按钮:


(2)WHEN-CLEAR-BLOCK


(3)PRE-QUERY


(4)WHEN-CLEAR-BLOCK


(5)POST-QUERY


(6)WHEN-NEW-RECORD-INSTANCE


(7)WHEN-NEW-ITEM-INSTANCE


12.点击“New”时:


(1)WHEN-NEW-RECORD-INSTANCE


(2)WHEN-NEW-ITEM-INSTANCE


13.点击“EditField”时:


(1)KEY-EDIT


14.点击“WindowHelp”时:


(1)KEY-HELP


15.点击“ClearRecord”时:


(1)WHEN-REMOVE-RECORD


(2)POST-QUERY


(3)WHEN-NEW-RECORD-INSTANCE


(4)WHEN-NEW-ITEM-INSTANCE


16.点击F4关闭时:


(1)KEY-EXIT


(2)POST-FORM


17.点击“CloseForm”按钮关闭时:


(1)KEY-EXIT


(2)POST-FORM


18.点击“Translations”按钮时:


(1)TRANSLATIONS


19.点击小叉号关闭时:


(1)WHEN-WINDOW-CLOSED


(2)CLOSE-WINDOW


(3)KEY-EXIT


(4)POST-FORM


20.选中LOV列表:


(1)KEY-LISTVAL


(2)WHEN-NEW-ITEM-INSTANCE


21.选中记录前面的小条时:


(1)WHEN-NEW-RECORD-INSTANCE


(2)WHEN-NEW-ITEM-INSTANCE(数据项级)


(3)WHEN-NEW-ITEM-INSTANCE


22.光标上下移动时:


(1)WHEN-NEW-RECORD-INSTANCE


(2)WHEN-NEW-ITEM-INSTANCE

Tag标签: Oracle Form Builder触发器执行顺序
keim,毕业于安徽科技学院理学院,2003年开始对Web开发有浓厚的兴趣,并专注于C#/java Web开发,软件架构设计、分布式相关、项目管理、前端设计等等,实战派...
posted @ 2011-08-14 17:25  夜色狼  阅读(192)  评论(0编辑  收藏  举报