Home » Developer & Programmer » Forms » urgent: record groups
urgent: record groups [message #80683] Thu, 31 October 2002 15:34 Go to next message
Avadbala
Messages: 17
Registered: October 2002
Junior Member
hi all,

i have two text boxes(no.of records displayed is 5) to which the data has to be populated dynamically using record group. how do i get the data into the text boxes ? i have to see the data one at a time .

Appreciate your help
thanks
Re: urgent: record groups [message #80711 is a reply to message #80683] Wed, 06 November 2002 22:42 Go to previous message
Sethunath
Messages: 15
Registered: February 2002
Junior Member
in the WHEN-NEW-BLOCK-INSTANCE of YOUR_BLOCK, create a script as follows

DECLARE
N number;I number;
CURSOR YOUR_CURSOR IS SELECT COLOUMN1,COLUMN2 FROM TABLE1 ;
BEGIN
if :system.block_status in('NEW') THEN
LAST_RECORD;
FOR REC IN YOUR_CURSOR LOOP
CREATE_RECORD;
:YOUR_BLOCK.TEXT_BOX1:=REC.COLOUMN1;
:YOUR_BLOCK.TEXT_BOX2:=REC.COLOUMN2;
END LOOP;
FIRST_RECORD;
END IF;
END;
Previous Topic: Opening a file -- Urgent
Next Topic: ICONS are not displaying in FORMS 6i
Goto Forum:
  


Current Time: Sat Mar 02 21:13:35 CST 2024