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

Tong Siew Pui (sptong_at_singnet.com.sg) wrote:
: 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 want to validate a field, use the when-validate-item trigger. In the trigger code a Raise Form_Trigger_Failure statement, if the validation fails. This will cause the trigger to fail. And since the when-validate-item trigger fires when a user is moving out of an item (Including commit processing), after changing its value,failure of this trigger causes the cursor to return back to the item. Changing the value in this trigger will cause the when-validate-item trigger to fire again. Thus, you would be able to validate the value in the item, till it is correct, using a when-validate-item trigger.

Hope this helps.

--
---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
       ** Different is Not Better. Better is not Different **
---------------------------------------------------------------------------