Form Trigger Sequence Demo Form

最新推荐文章于 2025-11-26 14:12:29 发布

最新推荐文章于 2025-11-26 14:12:29 发布 · 132 阅读

文章标签：

#数据库

本文详细介绍了FormTrigger在不同操作下的触发顺序，并提供了一个演示工具DemoForm，帮助读者理解各种Trigger是如何按顺序触发的。此外，还列举了典型操作如打开表单、新增记录等时的Trigger触发流程。

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.youkuaiyun.com/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]