Re: Oracle Forms Navigation Problem
From: Brian Membrey <horsemth_at_mel.switch.net.au>
Date: 1997/02/21
Message-ID: <01bc1fa6$1410aa80$2ea966cb_at_default>#1/1
Date: 1997/02/21
Message-ID: <01bc1fa6$1410aa80$2ea966cb_at_default>#1/1
Seems to me that your validation does not RAISE FORM_TRIGGER_FAILURE when the error is detected. Raising the exception will prevent the cursor moving regardless of AUTO_SKIP and this is the standard method of restricting the user to the invalid item. Hence GO_ITEM is not required ... as a general rule, any GO_ builtin is restricted from WHEN_ as the GO_ could change the focus of the form.
IF :item_1 <> 'ABC' THEN
message('Not valid');
RAISE FORM_TRIGGER_FAILURE;
END IF;
will never move from :item_1 is the value <> 'ABC'
Received on Fri Feb 21 1997 - 00:00:00 CET