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!

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

988474Feb 8 2013 — edited Feb 19 2013
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
This post has been answered by Andreas Weiden on Feb 8 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2013
Added on Feb 8 2013
4 comments
425 views