Note: In form builder, triggers 'execution hierarchy' caused funny issue in enter-query mode.
来源:互联网 发布:怎么做淘宝代理 编辑:程序博客网 时间:2024/05/16 16:00
Today, I'm almost tortured by the weird form behavior in enter-query mode in one of my custom forms.
Yesterday, I don't remeber exactly when, the block could still turn to light-blue when I hit F11 to enter 'enter-query' mode. But later I noticed it didn't change but always in white color.
I checked all the properties of the form, block and item, but none look suspicious. I also compare the properties with those in a standard form. Also nonthing suspicious.
Later I tried to copy all the objects, including blocks,lov,record groups, program units etc into a new form and run , still the same. How come? It has been torturing me almost about 4 hours.
Finally I checked metalink and found a note(133933.1) about how to change color of item in enter-query mode, actually in Oracle form there's no such attribute to easily set this. The note provided a sample plsql unit to loop all the item and set different visual attribute for items in normal mode and enter-query mode. So suddenly I thought it's the trigger that cause the weird behavior. So I delete some triggers and it proved my guess. After some narrowing down, I finally located it's the 'when-new-record-instance' trigger. I know the standard feature must be in app_standard.even('when-new-record-instance'), so I added it to block level 'when-new-record-instance' trigger and it worked. Then how come the form lever one was not executed? Then I realized it's the 'execution hierarchy' I tried to set this block level one to 'Before' and 'After' and 'Before' behaves what I expected. So it's solved.
- Note: In form builder, triggers 'execution hierarchy' caused funny issue in enter-query mode.
- ENTER-QUERY Mode
- SQL Query execution sequence in WHERE clause
- An issue caused by Initial Value in boost sparse matrix
- Use Triggers in Silverlight
- Triggers in Oracle Forms
- Interaction triggers in WPF
- form builder中Execution Hierarchy的三个不同的属性Before、Override、after的区别
- Form Builder开发中触发器的执行层次(Execution Hierarchy)
- Oracle Blocking Issue with Lock Table in Exclusive Mode
- [转]Finding a query in UCM using the query builder
- Funny In C++ 开篇
- Note 910879 - Attributes are not displayed in Query Designer
- collection hierarchy in java
- YUM issue in F11_64
- pthread issue in program
- issue in Emacs24
- Funny In C++ 计算机基础
- J2EE中SQL语句自动构造方法
- 多线程:C#线程同步lock,Monitor,Mutex,同步事件和等待句柄
- 构架Domino CA中心之二
- 求助 C语言的单向链表
- linux 下连接 sqlserver
- Note: In form builder, triggers 'execution hierarchy' caused funny issue in enter-query mode.
- 整合SVN与Apache
- Python script redirection detection, shell '<' or anonymous piple
- 木炭和沉香
- 纪念那些日子
- 数学与C#编程
- Microsoft Asp.Net Ajax 1.0 脚本注册和UpdatePanel的事件控制(1)
- 经典文章收藏
- 如何用在代码中通过query接口来取结果集。