using go_record built-in
HI
I have a master block and detail block though the detail block is populated by the procedure which populates when user double mouse click on the master block.
Now,if user moves up and down the master record i have to clear the detail block.
I am using key-up and key-down trigger to do that.I have to pick up the current record of the master block then go to detail block and clear the records.Then the cursor will be back to the original record on the master block.I am using the following code.But the form is not compiling.Any idea what may be wrong.
*********************
KEY-DOWN Trigger
**********************
DECLARE
rec_num number;
BEGIN
-- to catch the current record of the master block
rec_num:=:System.Cursor_Record -1;
-- clear the detail block
GO_ITEM('DETAIL.ITEM');
CLEAR_BLOCK(NO_VALIDATE);
-- to reset focus back to the master block to the current record of the master block
GO_BLOCK('MASTER');
GO_RECORD(:MASTER.rec_num);
END;