This discussion is archived
4 Replies Latest reply: Feb 10, 2013 7:21 PM by 988474 RSS

[SOLVED] After post trigger go to the specific item. (Oracle Forms 10g)

988474 Newbie
Currently Being Moderated
I have this layout

http://img339.imageshack.us/img339/975/capturetbo.png

and a post trigger insert and update
                IF  :item1 IS NULL
          AND :item3 IS NOT NULL THEN
                    alert_id := FIND_ALERT('blank_alert');
                    SET_ALERT_PROPERTY(alert_id,ALERT_MESSAGE_TEXT,'Item3 must have a value.');
                    v_alert := SHOW_ALERT(alert_id);          
                    RAISE Form_trigger_Failure;
          END IF;
My problem was as it fires, the cursor will be on the item1.
I've already use
SET_ITEM_INSTANCE_PROPERTY
NEXT_ITEM
GO_ITEM
but it was all illegal. The cursor must be in the item3.

Don't question me why I do not set the item3 to required and why post triggers.
It is just that. It is the requirement.
Any bright Idea? Thanks!

And even when-validate-item triggers. It must be post triggers.
Is it possible? Thanks.

Edited by: reppihsrow on Feb 19, 2013 6:02 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points