ORACLE FormBuilder触发器执行顺序
2024-09-30 10:45:00
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
最新文章
- python之(re)正则表达式下
- ORACLE临时表总结
- js中substring与substr的学习。
- 内核移植和文件系统制作(2):linux内核最小系统和initramfs文件系统
- lua string 库
- AsyncSocket的使用
- LeetCode_Set Matrix Zeroes
- cocos2d-x中的Box2D物理引擎
- Spring AOP基于xml配置实例
- String、StringBuffer和StringBuilder区别及性能分析
- python之~【空格】可不能随便加唷~
- HTML基础1
- myeclipse环境搭建
- Entity Framework 框架
- Django组件-用户认证
- (转载)解决NVIDIA显卡驱动“没有找到兼容的图形硬件”的问题
- [离散时间信号处理学习笔记] 8. z逆变换
- 【数学建模】day01-线性规划问题
- Announcing the Operate Preview Release: Monitoring and Managing Cross-Microservice Workflows
- golang:mime.Decode、mime.DecodeHeader
热门文章
- CodeForces Gym 100500A A. Poetry Challenge DFS
- Linux下双网卡绑定(bonding技术)
- Spring的qualifier标签
- http://love3400wind.blog.163.com/blog/static/7963080120132794359703/
- WCF 超时情形
- Ubuntu 安装Redis体验
- 匈牙利命名法——命名规范(知道这些再看Windows程序就轻松多了)
- 更快、更强——解析Hadoop新一代MapReduce框架Yarn(CSDN)
- BX2001: IE 支持使用 window.clipboardData 访问系统剪贴板,Chrome 和 Safari 中存在类似的 Clipboard 对象但尚未实现,Firefox 和 Opera 不支持这类对象
- HDU 5067 (状态压缩DP+TSP)