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
(只将填写的记录与数据库中已存在的记录作{wy}性的验证,如果只是页面上的数据重复而数据库中没有与其重复的值则不会报错.)

(2)WHEN-NEW-RECORD-INSTANCE

(3)WHEN-NEW-ITEM-INSTANCE

3.当点击“保存”时

(1)WHEN-VALIDATE-RECORD
(将页面上的所有数据提交到数据库,若页面上有重复的数据,则提交{dy}次时成功但只是将数据先写到数据库中一类似临时表的地方,在提交第二条重复记录的时候报错,执行事务回滚,原来执行成功的指令也将被撤消)

(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

郑重声明:资讯 【Oracle Form 触发器执行顺序(转)】由 发布,版权归原作者及其所在单位,其原创性以及文中陈述文字和内容未经(企业库qiyeku.com)证实,请读者仅作参考,并请自行核实相关内容。若本文有侵犯到您的版权, 请你提供相关证明及申请并与我们联系(qiyeku # qq.com)或【在线投诉】,我们审核后将会尽快处理。
—— 相关资讯 ——