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: 487
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

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: 83
Registered: September 2007
Location: India
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
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: 487
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
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: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
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
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: 487
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
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: 83
Registered: September 2007
Location: India
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
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: 487
Registered: January 2007
Location: Chennai
Senior Member

hi sinida

what difference from mine(code)

kanish
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: 487
Registered: January 2007
Location: Chennai
Senior Member

Thanks

I got it

kanish
Previous Topic: get operating system user
Next Topic: working Directory Of 10g DS
Goto Forum:
  


Current Time: Sun Dec 11 02:38:49 CST 2016

Total time taken to generate the page: 0.10549 seconds