Form Trigger执行顺序
来源:互联网 发布:热点设置软件 编辑:程序博客网 时间:2024/05/16 05:11
之前转了一个关于Trigger次序的帖子见(http://blog.csdn.net/pan_tian/article/details/7535875),但是不太全,今天又找到一贴
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-INSTANC
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.光标上下移动时
(1) WHEN-NEW-RECORD-INSTANCE
(2) WHEN-NEW-ITEM-INSTANCE
- Form Trigger执行顺序
- FORM trigger执行顺序
- Oracle Form Trigger执行顺序
- Form中Trigger的执行顺序
- Form中Trigger的执行顺序(转)
- Form中Trigger的执行顺序(转)
- Trigger的执行顺序
- form 触发器执行顺序
- oracle form 触发器执行顺序
- oracle form 触发器执行顺序
- oracle form 触发器执行顺序
- Oracle Form 触发器执行顺序
- Oracle Form 触发器执行顺序
- Form触发器的执行顺序
- Form中触发器trigger的执行层次关系
- Oracle Form 触发器执行顺序【转】
- 【转】Oracle Form 触发器执行顺序
- Form Trigger Sequence Demo Form
- Forms trigger Firing Sequence
- ffmpeg 转换VC工具 V1.1.1
- CFI查询(二)
- sun.net.ftp.FtpClient 上传文件和文件夹应用(改变相关文件中的内容)
- 错误 $LocalActivityRecord@40533030 is not valid; is your activity running?
- Form Trigger执行顺序
- c语言连接mysql中文显示乱码问题-解决方案
- 函数指针问题
- struts2 三 表单控件标签
- 内存管理: malloc()与free()的一种基于池表结构的实现
- 我的Linux PC开发环境
- SQL 2008 从零基础到如今(不断更新中)
- java加密技术
- QTableView双击 获取 一行数据