Oracle Forms 10g: Dynamic list item
Dynamic list items:
How you can make a dynamic List of values in oracle forms builder, most developer uses many techniques to make List of values. I will tell you a simple and very suitable method for making List item dynamically.
Follow me:
/ munir.du
Forms Level When-New-Form-Instance
DECLARE
rg_products RecordGroup;
rg_product_name VARCHAR2(5) := 'PNAME';
plist_ID Item := Find_Item('ORDER_ITEMS.PRODUCT_ID');
nDummy NUMBER;
BEGIN
rg_products := Find_Group(rg_product_name);
-- Delete any existing Group first
IF NOT Id_Null(rg_products) THEN
Delete_Group(rg_products);
END IF;
-- Now create a Record Group using a SQL query
-- Your Query must have a Label and a Value (two Columns)
-- and the data types must match your item type
rg_products := Create_Group_From_Query(rg_product_name,'SELECT product_name, to_char(product_id) FROM summit.products');
-- Clear the existing List
Clear_List(plist_ID);
-- Populate the Record Group
nDummy := Populate_Group(rg_products);
-- Populate the List Item
Populate_List('ORDER_ITEMS.PRODUCT_ID',rg_products);
END;
