how to use the get_record_property in a multi record blcok [message #380921] |
Wed, 14 January 2009 01:45  |
mylraj
Messages: 16 Registered: January 2009 Location: Manama
|
Junior Member |
|
|
hi,
i am trying to find out the status of records in a given block. The problem is if i have a 7 records in a block out of 5 record is displayed, when i move the cursor, on the 5th record, i will get the 6th and 7th record.
The following code is not working from 6th record onwards.
i am just new to forms, can some one help me on this
DECLARE
CURR_REC NUMBER(5);
BEGIN
GO_BLOCK('UM_TEST');
IF :SYSTEM.LAST_RECORD ='TRUE' THEN
FIRST_RECORD;
CURR_REC:=1;
ELSE
CURR_REC:=1;
END IF;
WHILE TRUE
LOOP
MESSAGE( CURR_REC || GET_RECORD_PROPERTY(CURR_REC,'UM_TEST',STATUS));
CURR_REC:=CURR_REC + 1;
GO_RECORD(CURR_REC);
IF :SYSTEM.LAST_RECORD='TRUE' THEN
EXIT;
END IF;
END LOOP;
END;
|
|
|
|
|