| Multiple Records [message #135890] |
Sun, 04 September 2005 01:21  |
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
|
Senior Member |
|
|
I want to show the multiple records in the multi row datablock. I have write following cursor to get the record in the datablock. but it gives me the last record only.
DECLARE
DEPCNT NUMBER;
CURSOR C1 IS SELECT STOCK_CODE,CURRENCY,SELL_PRICE
FROM STOCK_MASTER;
BEGIN
OPEN C1;
FIRST_RECORD;
LOOP
FETCH C1 into :GROUP_METAL_PRICE.STONE_CODE,
:GROUP_METAL_PRICE.CURRENCY,
:GROUP_METAL_PRICE.STANDARD_PRICE;
EXIT WHEN C1%NOTFOUND;
GO_BLOCK('CONTROL');
GO_ITEM('CONTROL.EDIT');
NEXT_RECORD;
END LOOP;
CLOSE C1;
END;
Please tell me what is the mistake in this.
Its urgent.
Samit gandhi
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
