OraFAQ Forum: Forms » how can i create the dynamic list item ?

Home » Developer & Programmer » Forms » how can i create the dynamic list item ? (Form 6i, Widows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can i create the dynamic list item ? [message #318874]

Thu, 08 May 2008 05:47

mm_kanish05
Messages: 493
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

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

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

mm_kanish05
Messages: 493
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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

mm_kanish05
Messages: 493
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

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

Report message to a moderator