how to count number of items present in a data block [message #520304] |
Sat, 20 August 2011 12:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kalpataru
Messages: 72 Registered: January 2010 Location: INDIA
|
Member |
|
|
hi all,
my requirement is how to count how many items present in a particular data block in oracle forms 10g.
whether it is a text_item or display_item or list_item etc is there any method to do this.
i have written this when-button pressed but the problem is
how to get the next item name in the block
DECLARE
V_COUNT NUMBER:=0;
V_FIRSTITEM VARCHAR2(100):='';
BEGIN
GO_BLOCK('BLOCK_ITEMCOUNT');
V_FIRSTITEM := GET_BLOCK_PROPERTY('BLOCK_ITEMCOUNT', FIRST_ITEM);
LOOP
V_COUNT := V_COUNT + 1;
EXIT WHEN GET_ITEM_PROPERTY(V_FIRSTITEM, NEXTITEM) IS NULL;
--V_FIRSTITEM := GET_BLOCK_PROPERTY('BLOCK_ITEMCOUNT', NEXTITEM);
--V_COUNT := V_COUNT + 1;
END LOOP;
END;
|
|
|
|
|
|