OraFAQ Forum: Forms » see my code for runtime lov

Home » Developer & Programmer » Forms » see my code for runtime lov

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

see my code for runtime lov [message #165282]

Wed, 29 March 2006 04:13

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master
see my code for runtime lov

DECLARE
X BOOLEAN;
rg_name VARCHAR2(40) := 'RG_CNTRY';
rg_id RecordGroup;
lov_id LOV;
qry varchar2(4000);
errcode number;
BEGIN
rg_id := Find_Group( rg_name );
qry := 'SELECT * from dept' ;
IF NOT Id_Null(rg_id) THEN
Delete_Group( rg_id );
END IF;
rg_id := Create_Group_From_Query( rg_name,qry);
errcode := Populate_Group( rg_id );
lov_id := Find_LOV('LV_COUNTRY');
Set_LOV_Property(lov_id,GROUP_NAME,'RG_CNTRY');
X := SHOW_LOV('LV_COUNTRY',110,25);
END;

when i press button then system give this error

Frm-41091 : cannot find lov : invalid id.

Frm-41828 : lov dose not exist.

please give me idea

Thanking you

Aamir

Report message to a moderator