drop down list [message #86597] |
Wed, 13 October 2004 00:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hudo
Messages: 165 Registered: May 2004
|
Senior Member |
|
|
--WHEN-NEW-FORM-INSTANCE
DECLARE
group_id RecordGroup;
list_id Item := Find_Item('MYBLOCK.THELIST');
status NUMBER;
rg_name varchar2(40) := 'recgroup';
BEGIN
clear_list(list_id);
group_id := Find_Group(rg_name);
IF NOT id_null(group_id) then
Delete_Group(group_id);
End if;
group_id := Create_Group_From_Query(rg_name,
'SELECT ENAME FROM EMP');
status := Populate_Group(rg_name);
Populate_List(list_id, group_id);
END;
What is wrong here ?
These errors occur:
FRM-30351: No list elements defined for list item.
FRM-41334: Invalid record group for list population.
|
|
|
Re: drop down list [message #86601 is a reply to message #86597] |
Wed, 13 October 2004 03:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Ani
Messages: 56 Registered: November 2000
|
Member |
|
|
if u have defined a record group then pls assign an initial value to it and try running the above code.
Ani
|
|
|