Home » Developer & Programmer » Forms » pop list values (forms 6i)
pop list values [message #599760] Mon, 28 October 2013 12:31 Go to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
I have one drop down list box from which i want to do add or copy the values chosen from the list to another text box and then using this copied values ,i will pass them as parameters to run report.This list is getting populated using recordgroup and then what ever user choses , it will be added to the another text box with space or delimiter.
Re: pop list values [message #599883 is a reply to message #599760] Tue, 29 October 2013 16:28 Go to previous messageGo to next message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
Dear use

		 
If GET_LIST_ELEMENT_VALUE ('select_item',1) IS NULL Then
   DELETE_LIST_ELEMENT('select_item',1 );
   DELETE_LIST_ELEMENT('FEATURES.FEATURES', 1 );
End If; 


Add_List_Element('select_item', 
                (GET_LIST_ELEMENT_COUNT
                ('select_item')+1), 
                       :avail_item,
                       :avail_item); 


Hope you will get something

Regard
Mughal

[Updated on: Tue, 29 October 2013 16:29]

Report message to a moderator

Re: pop list values [message #599944 is a reply to message #599883] Wed, 30 October 2013 06:21 Go to previous messageGo to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
no , i meant i will adding values selected from list box to another text box .In simple term chosen values of list should be added in the text box.
Re: pop list values [message #600008 is a reply to message #599944] Wed, 30 October 2013 15:59 Go to previous message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
I think you did not understand same thing i am doing take this .fmb then tell me what else you want. you can can make it change list style "Tlist" and also you can change TRIGGER-WHEN-LIST-CHANGED

create table available(av_di varchar2(8),avail_item varchar2(25));

insert into available values('001','Arbor');
insert into available values('002','Fenced');
insert into available values('003','Electric Heating');

commit;




Regard
Mughal


[Updated on: Wed, 30 October 2013 16:08]

Report message to a moderator

Previous Topic: Error while inserting date column
Next Topic: updating value of table from textbox which is on form
Goto Forum:
  


Current Time: Wed Apr 24 23:50:31 CDT 2024