Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Key-Next-Item & When-Validate-Item Triggers - Navigation Help Needed

sharpeJul 6 2009 — edited Jul 8 2009
Hi. I historically use when-validate-item triggers to validate the data entered in an item. If the validation logic fails then I can 'Raise Form_Trigger_Failure;' and the person must attempt to re-enter a valid value before getting to the next item.

However, in the form I'm creating now I need to validate the value entered and if it fails the validation logic then I need to move the cursor to another item where they are required to enter an explanation for the value they entered initially. This is a big problem as I cannot use 'go_item()' from within a 'when-validate-item' trigger. And I can't simply move the validation logic to a 'key-next-item' trigger either because then the user could accidently by-pass the validation logic if they mouse out of the field instead of pressing the Tab or Enter keys.

How can I accomplish this task? When my 'when-validate-item' trigger fails then I need to still move the cursor to another item. Certainly there must be some means of accomplishing this. Please let me know your thoughts. Thanks in advance.
This post has been answered by user346369 on Jul 7 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2009
Added on Jul 6 2009
11 comments
10,685 views