| How to create list item which type is number [message #379673] |
Wed, 07 January 2009 10:17  |
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
|
Senior Member |
|
|
well i create a list item which type is number like this
WHEN-NEW-FORM-INSTANCE
DECLARE
rgname varchar2(40) :='Dept';
status number;
rgroup recordgroup;
Begin
rgroup := create_group_from_query (rgname,'select
to_char(item_no),to_char(item_no) item_no from item2');
status:=populate_group(rgroup);
clear_list('item_no');
populate_list('purchase2.no',rgroup);
End;
its give me error
FRM-4139 ITEM-ITEM-NO IS NOT A VALID LIST ITEM
now my question is when i create a list item which type is varchar2 i create like this
I Create a procedure
PROCEDURE itemname(p_ListName in varchar2, p_SrcBox in Varchar2) IS
v_Rg RecordGroup;
BEGIN
v_RG := Find_Group('itemname');
END;
then in NEW-FORM-INSTANCE
Declare
v_GrpID RECORDGROUP;
v_rg NUMBER;
Begin
v_GrpID := CREATE_GROUP_FROM_QUERY('itemname', 'SELECT item_name, to_char(item_name) item_name FROM item2 ORDER BY 1');
v_rg := POPULATE_GROUP(v_GrpID);
IF
v_rg = 0 THEN
POPULATE_LIST('purchase2.item_name_pur', v_GrpID);
POPULATE_LIST('SALE2.item_name_sale', v_GrpID);
END IF;
Its working on list item which type is Varchar2
how can i create a list item which type is number. there is any way to create a list item with procedure like i made for varchar2
Thanks
Shahzaib Ismail
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
