When-validate-item doesnt always work in 9i [message #82222] |
Thu, 08 May 2003 06:55 |
Zaire
Messages: 36 Registered: October 2002
|
Member |
|
|
Hi,
Could anyone tell me why WHEN-VALIDATE-ITEM doesnt always work in Oracle 9i. I have an item with a WHEN-VALIDATE-ITEM trigger attached to it. If I type a value in it and immediately press the F10 (key-commit) button, the trigger does not fire. However, if I type a value, then hit the ENTER button and then press F10, it works.
A solution to this is to include the VALIDATE(ITEM_SCOPE) built-in in the key-commit trigger, but this is definitely a bug in 9i ... or is it? Any sugestions guys? Maybe Im missing something.
|
|
|