hi all
i am using forms 12R4 Database 12c
i am using the following execute query its working and executing the query but its not giving the same record.
when i put no 12 to execute query along with other record its executing but cursor does not go to the same searched record.
here is the code
DECLARE
blk_id Block;
BEGIN
blk_id := Find_Block('first_block1');
IF NOT Id_Null(blk_id) THEN
IF (:first_block1.ID_no is not null) THEN
SET_BLOCK_PROPERTY(blk_id,DEFAULT_WHERE,'ID_No=' || :second_block.ID_no);
GO_block('block_name');
EXECUTE_QUERY;
END IF;
END IF;
IF :System.Last_Record <> 'TRUE' THEN
LAST_RECORD;
ELSE
FIRST_Record;
END IF;
END;
to highlight the searched record is it possible?
please guide me.