Re: HELP ! how to "navigate" in FORM 4.5 trigger ????

From: Swapan Jha <jhas_at_ix.netcom.com>
Date: 1995/09/07
Message-ID: <42n2m4$ef0_at_ixnews5.ix.netcom.com>#1/1


In <42mukb$ufb_at_lantana.singnet.com.sg> sptong_at_singnet.com.sg (Tong Siew Pui) writes:
>
>In Oracle Form 4.5, you cannot navigate (example, go_block, go_item)
>if you are using the on-message, post_block or pre_block trigger. You
>also can't do that when using a when-validate-item trigger.
>
>If I need to validate a field after the user enter some value in the
>field, what trigger should I use if I want the cursor to go back to
>the validating field if the user input the wrong value. I tried using
>post-block, but the go-item trigger is not allowed.
>
>What should I do ???
>

 If you check the documentation, you can't called restricted proc inside any post, pre, on triggers, i.e. go_item, go_block, etc.

 Try using Raise Form_Trigger_failure in your trigger when ever there is an error.

Swapan Jha Received on Thu Sep 07 1995 - 00:00:00 CEST

Original text of this message