Home » Developer & Programmer » Forms » how to use the get_record_property in a multi record blcok (Oracle 10g Forms)
how to use the get_record_property in a multi record blcok [message #380921] Wed, 14 January 2009 01:45 Go to next message
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;
Re: how to use the get_record_property in a multi record blcok [message #380923 is a reply to message #380921] Wed, 14 January 2009 01:56 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear Friend,

Go in your block property and make query all records property = TRUE.

Check it out and tell me is it working or not.

Regards,
Azam Khan
Re: how to use the get_record_property in a multi record blcok [message #380925 is a reply to message #380923] Wed, 14 January 2009 02:19 Go to previous message
mylraj
Messages: 16
Registered: January 2009
Location: Manama
Junior Member

Hi Khan,

It's working

Thank you
Previous Topic: RegisterWebUtil not found.
Next Topic: Pdf Viewer in Forms 10g
Goto Forum:
  


Current Time: Sat Dec 10 03:17:42 CST 2016

Total time taken to generate the page: 0.05247 seconds