| urgent: record groups [message #80683] |
Thu, 31 October 2002 15:34  |
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  |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
