HI All,
I am using Forms 10G.
I have a details block and in this non of the fields are mandatory .
But I have written a condition when 1st 2 columns are not null then the nnest 2 columns should be filled in with some data , else it will throw error .
And so far it is working fine .
So if the 1st 2 columns are filled and 2nd 2 columns are null then it is showing error . But the cursor is going to 1st column .
I want the cursor should be in the particular column where it is null .
I have wiitten like this :-
IF :Block1.col3 IS NULL THEN
Message('Error');
--:System.Cursor_Record := '9' ;
SET_ITEM_PROPERTY('ITEM_SUP_DUTY_RATE_T.DUTY_VAL',REQUIRED,PROPERTY_TRUE);
SET_ITEM_PROPERTY('ITEM_SUP_DUTY_RATE_T.DUTY_VAL',KEEP_POSITION,PROPERTY_TRUE);
RAISE Form_Trigger_Failure;
Message('Hello 2');
END IF;
But still the cursor is moving to the first column .
I have tried both REQUIRED and KEEP_POSITION in one time and also separatly .