Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Developer & Programmer » Forms » how can i create the dynamic list item ? (Form 6i, Widows xp)
how can i create the dynamic list item ? [message #318874] Thu, 08 May 2008 05:47 Go to next message
mm_kanish05
Messages: 244
Registered: January 2007
Location: Chennai
Senior Member

HI
I had create the list item, and how can insert list value in running time(dynamically).

Please guide me a good and simple example
or step by step manner.

wbr
kanish
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319076 is a reply to message #318874 ] Thu, 08 May 2008 23:58 Go to previous messageGo to next message
sinida1984
Messages: 29
Registered: September 2007
Junior Member
Hi
You can try using add_list_element() in any trigger where u need to put it dynamically. Please search on add_list_element in help. You will get what is the syntax..
Eg:- add_list_element('TEXT_ITEM4', 1, 'c', 'c');
will add 'c' into list element named text_item4 as 1st list element.
if u give like add_list_element('TEXT_ITEM4', 3, 'c', 'c');
will add 'c' into list element named text_item4 as 3rd list element.

Regards
Sinida
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319091 is a reply to message #318874 ] Fri, 09 May 2008 00:47 Go to previous messageGo to next message
mm_kanish05
Messages: 244
Registered: January 2007
Location: Chennai
Senior Member
hi sinida

Thanks

I need in step by step like declaration,creation,addtiong like

can u do the favour.

wbr
kanish
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319096 is a reply to message #319091 ] Fri, 09 May 2008 01:01 Go to previous messageGo to next message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Search this forum for 'add_list_element' and you will find entries like http://www.orafaq.com/forum/m/308008/67467/?srch=add_list_element#msg_308008 which contain the commands with which you need to be familiar.

David
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319163 is a reply to message #318874 ] Fri, 09 May 2008 04:20 Go to previous messageGo to next message
mm_kanish05
Messages: 244
Registered: January 2007
Location: Chennai
Senior Member
hi

I created plsql code on "When_new_form_instance" like

Declare
	 Cursor pg is (select partgroupno||'-'||groupname gpcode,partgroupno from partgroup);
	 cnt number(3) := 1;
begin
	  clear_list(:part);
	for i in pg loop
		 add_list_element(:Menu.part,cnt,i.gpcode,i.partgroupno);
		 cnt := cnt + 1;
	end loop;	 
end;


im getting error

unable to resolve reference to item

what is the issue and also non of item had not been add into that list also.

wbr
kanish
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319203 is a reply to message #319163 ] Fri, 09 May 2008 06:00 Go to previous messageGo to next message
sinida1984
Messages: 29
Registered: September 2007
Junior Member
Hi....
Your code should be like below...

Declare
Cursor pg is (select partgroupno||'-'||groupname gpcode,partgroupno from partgroup);
cnt number(3) := 1;
begin
clear_list(:part);
for i in pg loop
add_list_element('Menu.part',cnt,i.gpcode,i.partgroupno);
cnt := cnt + 1;
end loop;
end;

Regards
Sinida
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319205 is a reply to message #318874 ] Fri, 09 May 2008 06:08 Go to previous messageGo to next message
mm_kanish05
Messages: 244
Registered: January 2007
Location: Chennai
Senior Member
hi sinida

what difference from mine(code)

kanish
Report message to a moderator
Re: how can i create the dynamic list item ? [message #319207 is a reply to message #318874 ] Fri, 09 May 2008 06:14 Go to previous message
mm_kanish05
Messages: 244
Registered: January 2007
Location: Chennai
Senior Member
Thanks

I got it

kanish
Report message to a moderator
Previous Topic:get operating system user
Next Topic:working Directory Of 10g DS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 25 14:55:27 CDT 2008

Total time taken to generate the page: 0.02999 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.