| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
