Adsense Ad

Wednesday 18 September 2019

Oracle Forms: KEY-NEXT-ITEM / POST-TEXT-ITEM

Difference Between KEY-NEXT-ITEM and POST-TEXT-ITEM Triggers in Oracle Forms

Several times you must have faced this tricky interview question about the difference between KEY-NEXT-ITEM and POST-TEXT-ITEM triggers in Oracle Forms. This question is also prevalent in Oracle Apps Technical interviews. Although the functions of both the triggers are same, why has Oracle given them separately? Let us understand the differences between them in this article.

Difference Between KEY-NEXT-ITEM and POST-TEXT-ITEM Triggers


KEY-NEXT-ITEM
POST-TEXT-ITEM
The key-next-item trigger fires only when pressing TAB on the keyboard.Post-Text-Item fires once you leave the current item to the next item by a keyboard or a mouse.
It fires before the cursor is focused on the next item.It fires after the cursor is focused on the next item.
Without a key event, this trigger will not be fired.This trigger fires without a key event.



Please feel free to comment, if you find mistakes or errors in any of the topics. Your suggestions to improve the article helps us improve.

2 comments:

David Ziants said...

If redefining key-triggers, for example one wants to change the default navigation order, one should always validate the item by calling built-in ENTER, and then testing IF form_success THEN ...
This ensures proper handling if validation fails on the item, as the normal navigation logic is only done in the THEN part of the test.

Jonathan Samuel said...

An important different to add is that KEY-NEXT-ITEM allows navigation commands within it such as NEXT_ITEM or GO_ITEM
whereas POST-TEXT-ITEM does not allow navigation commands within it.