oracle_form_常用Trigger的触发时机-执行顺序.doc

???? 常用Trigger的触发时机 ????????? Form Level: Trigger 触发时机 PRE-FORM 启动Form, 第一个Block WHEN-NEW-FORM-INSTANCE PRE-xxx初始化结束后，焦点导航到Form时 POST-FORM 焦点离开Form时 POST-DATABASE-COMMIT Form上有数据库数据变化要提交时 WHEN-TABCHANGED 当Form上有Tab Canvas，Tab Page变化时触发 KEY-EXIT Form. WHEN-WINDOW-CLOSED 点击Windowclose图示. 如果通过F4关闭则不会触发这个trigger CLOSE-WINDOW 点击Windowclose图示, After WHEN-WINDOW-CLOSE ????????? Block Level: Trigger 触发时机 PRE-BLOCK BLOCK得到焦点，初始化之前 PRE-RECORD Record. After PRE-BLOCK, Before WHEN-NEW-BLOCK-INSTANCE WHEN-NEW-BLOCK-INSTANCE Block获得焦点时触发 WHEN-NEW-RECORD-INSTANCE Record获得焦点时触发. After WHEN-NEW-BLOCK-INSTANCE WHEN-VALIDATE-RECORD Recorditem validate通过后，block commit前触发 POST-RECORD 焦点离开Record触发 POST-BLOCK 焦点离开Block触发. After POST-RECORD PRE-INSERT Insert操作确认后commit前触发 PRE-UPDATE Update操作确认后commit前触发 PRE-DELETE Delete操作确认后commit前触发 ON-INSERT Insert 操作写入DB时触发 ON-UPDATE Update 操作写入DB时触发 ON-DELETE Delete 操作写入DB时触发 ON-LOCK 从DB中查询出的record, 在第一个发生值变化的操作时触发，lock之后其它的值变化操作不会再触发；直到commit后自动lock PRE-QUERY 在执行SQL前触发。可以用来设置数据块default_where, order_by等属性 POST-QUERY 执行SQL后，将查询的数据集提取到窗体记录各项之前触发 ????????? Item Level: Trigger Item Type 触发时机 PRE-TEXT-ITEM TextItem TextItem WHEN-NEW-ITEM-INSTANCE之前触发。隐藏的text item没有这个trigger WHEN-NEW-ITEM-INSTANCE All 可见Item得到焦点时触发 Canvas上显示的object item是没有这个trigger POST-CHANGE Item 如果Item状态或值有变化，在焦点离开item时触发 WHEN-VALIDATE-ITEM 所有可编辑的Item 有变化的item焦点移开时，在POST-CHANGE trigger之后触发 POST-TEXT-ITEM TextItem Validate item之后触发 KEY-LISTVAL TextItem LOV的TextItem选择value时触发 WHEN-LIST-CHANGED LIST 下拉列表选项变化时触发 WHEN-RADIO-CHANGED Radio Group Radio group的选中radio button项变化时触发 WHEN-BUTTON-PRESSED BUTTON Button点击或确定时触发 ?? 常见的Trigger触发顺序 Action Sequence Trigger Level Open Form（当打开FORM时） 1 PRE-FORM Form 2 PRE-BLOCK Block 3 PRE-RECORD Block 4 PRE-TEXT-ITEM Item 5 WHEN-NEW-FORM-INSTANCE Form 6 WHEN-NEW-BLOCK-INSTANCE Block 7 WHEN-NEW-RECORD-INSTANCE Block 8 WHEN-NEW-ITEM-INSTANCE Item Page Down /Up (查询出记录后翻页到前/后记录) 1 POST-RECORD Block