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) PER-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-INSTANE
在输入查询条件后点CTRL+F11
4) PRE-QUERY
5) WHEN-CLEAR-BLOCK
6) POST-QUERY
7) WHEN-NEW-RECORD-INSTANCE
8) WHEN-NEW-ITEM-INSTANCE
9.CTRL+F11
1) WHEN-CLEAR-BLOCK
2) PER-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) WHEN-EXIT
3) WHEN-NEW-RECORD-INSTANCE
4) WHEN-NEW-ITEM-INSTANCE
11手电筒查询过程
1) QUERY_FND(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.点击EDIT FIELD时
1) KEY-EDIT
14.点击window HELP时
1) KEY-HELP
15.点击CLEAR RECORD时
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.点击close FORM时
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.FORM切换到当前窗体时
1) WHEN-FORM-NAVIGATE
2) WHEN-NEW-ITEM-INSTANCE