ITPub博客

首页 > 数据库 > Oracle > Form Trigger Sequence Demo Form

Form Trigger Sequence Demo Form

原创 Oracle 作者:pan_tian 时间:2014-07-02 16:04:11 0 删除 编辑

Form Trigger太多太庞杂,新手往往很难上手,加上一些Trigger有点偏门,用的比较少,真到想用的时候,又不知道从哪下手。

所以之前就有想法写一个Demo Form,用于显示Trigger的执行顺序,今天发现已经有人写过这个东西了,也就不用重造这个轮子了。

作者:Francois Degrelle(Oracle ACE)
Site:http://sheikyerbouti.developpez.com/tutoforms10g/tutoforms10g.htm
可以从上边的页面下载,不过需要注册(法语),也可以从我的微盘下载,Link: http://vdisk.weibo.com/s/m5y_q

如何注册一个新的form到EBS系统,见:http://blog.csdn.net/pan_tian/article/details/7637810


This dialog allows you to understand what trigger fire and in what order when you use the application.

Before each particular action, you can clear the list of triggers window.

This window show you what trigger is firing in what order and from what block and what item.


下面为一些典型动作所触发的事件

* Form打开触发的事件

When-Create-Record [CTRL]
Pre-Form []
When-Create-Record [DEPT]
Pre-Block [DEPT]
Pre-Record [DEPT]
Pre-Text-Item [DEPT.Deptno]
When-New-Form-Instance [DEPT.Deptno]
When-New-Block-Instance [DEPT.Deptno]
When-New-Record-Instance [DEPT.Deptno]
When-New-Item-Instance [DEPT.Deptno]
When-Window-Activated [DEPT.Deptno]


*按下F11

On-Clear-Details [DEPT.Deptno]
Post-Text-Item [DEPT.Deptno]
Post-Record [DEPT]
When-New-Record-Instance [DEPT.Deptno]
When-New-Item-Instance [DEPT.Deptno]


*输入Deptno:10,然后触发Ctrl+F11

Pre-query [DEPT]
Pre-Select [DEPT]
Post-Select [DEPT]
Post-Query [DEPT]
On-Close [DEPT]
Pre-Record [DEPT]
Pre-Text-Item [DEPT.Deptno]
On-Populate-Details [DEPT.Deptno]
Post-Text-Item [DEPT.Deptno]
Post-Record [DEPT]
Post-Block [DEPT]
When-Create-Record [EMP]
Pre-Block [EMP]
Pre-Record [EMP]
Pre-Text-Item [EMP.Empno]
Post-Text-Item [EMP.Empno]
Post-Record [EMP]
Pre-query [EMP]
Pre-Select [EMP]
Post-Select [EMP]
Post-Query [EMP]
Post-Query [EMP]
Post-Query [EMP]
On-Close [EMP]
Pre-Record [EMP]
Pre-Text-Item [EMP.Empno]
Post-Text-Item [EMP.Empno]
Post-Record [EMP]
Post-Block [EMP]
Pre-Block [DEPT]
Pre-Record [DEPT]
Pre-Text-Item [DEPT.Deptno]
When-New-Record-Instance [DEPT.Deptno]
When-New-Item-Instance [DEPT.Deptno]
Post-Text-Item [DEPT.Deptno]
Post-Record [DEPT]
Post-Block [DEPT]


*新增一个员工信息,Save,所触发的事件

When-Validate-Item [EMP.Job]
Post-Text-Item [EMP.Job]
When-Validate-Item [EMP.Deptno]
When-Validate-Record [EMP]
Post-Record [EMP]
Post-Block [EMP]
When-Validate-Item [CTRL.Aff]
When-Validate-Record [CTRL]
Pre-Commit []
Pre-Insert [EMP]
On-Insert [EMP]
Post-Insert [EMP]
When-Validate-Record [CTRL]
Post-Forms-Commit []
On-Commit []
Post-Database-Commit []
Pre-Block [EMP]
Pre-Record [EMP]
Pre-Text-Item [EMP.Job]
When-New-Item-Instance [EMP.Job]


Related Topic:

(V45) Trigger Execution Sequence in Forms 4.5 

Form Trigger执行顺序

Trigger Toutorial




<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1204819/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 2012年读过的书和看过的电影
下一篇: SSH Got WARNING: 'POSSIBLE DNS SPOOFING DETECTED'
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章