Fetch Populate group with query in text item.
852593Apr 30 2011 — edited Apr 30 2011Hello,
I have following query to take sql from a table populate a record group with that sql and now finally I want the result set in the text item of forms. Please help me how to achieve this.
declare
cursor c1 is select sqltext from tablename where col1 = 100;
vsql varchar2(2000);
begin
open c1;
fetch c1 into vsql;
POPULATE_GROUP_WITH_QUERY('my_rec_group', vsql);
close c1;
END;
This is just the example. Can you please tell me what to do next to get the record group value in text item. I want by default the first item in record group to be shown in the text item as there will be only one record in the record group. This is the pl/sql which has strike my mind but I have tried several ways, it is not working.
Can you please help me reframe this code so that I can populate the record group in a text item of forms 10g ?