Home » Developer & Programmer » Forms » drop down list
drop down list [message #86597] Wed, 13 October 2004 00:51 Go to next message
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
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
Previous Topic: urgent help needed
Next Topic: Urgent ----Help me
Goto Forum:
  


Current Time: Sat Sep 07 15:14:59 CDT 2024