Home » Developer & Programmer » Forms » How to create list item which type is number
How to create list item which type is number [message #379673] Wed, 07 January 2009 10:17 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
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

Re: How to create list item which type is number [message #380022 is a reply to message #379673] Thu, 08 January 2009 20:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
shahzaib,

You have been posting on this forum quite a few times now. Will you get with the programme and use the 'code' tags!!!

David
Re: How to create list item which type is number [message #380023 is a reply to message #379673] Thu, 08 January 2009 20:53 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Leave the dynamic lists alone and use record_groups, they are simpler.

David
Previous Topic: Developer 2000-1.3.2 and 2.1 on MS Windows Vista
Next Topic: Thai not support
Goto Forum:
  


Current Time: Sun Dec 04 02:39:12 CST 2016

Total time taken to generate the page: 0.10178 seconds