| How to pass data from one list item to another list item [message #161016] |
Wed, 01 March 2006 07:40  |
sikorsky05
Messages: 40
Registered: October 2005
|
Member |
|
|
I have 2 list items in a form...
1st one is being populated by
select pdt_code from genfrac_R_PDT where model = 'PBLH60'
order by pdt_code desc;
2nd one is being populated by
Select f.part_eipn,s.PDT
from GENFRAC_r_part_EIpn f, event_log e,event_status s
where f.PART_EIPN = e.EIPN
and e.log_no = s.log_no
and f.model = 'PBLH60'
and e.model = 'PBLH60'
and s.MODEL = 'PBLH60'
and s.pdt = :block10.model_list (1st list item is in block10)
order by part_eipn;
I want to be able to choose a pdt_code from the 1st List Item and have that filter what gets displayed in the 2nd list item
I am populating the 1st list item by the procedure below.
2nd list item is being populated by a similar procedure.
-- THIS PROCEDURE WILL LOAD THE AIRCRAFT DROPDOWN LIST ITEM.
PROCEDURE LOAD_ACLIST IS
CURSOR cAClist is
select pdt_code from genfrac_R_PDT where model = 'PBLH60'
order by pdt_code desc;
vAClist cAClist%rowtype;
i integer;
example varchar2(10);
BEGIN
-- initialize the list index variable.
i := 1;
-- clear_list('OP_EVENT_BUTTON.AC_LIST');
Clear_list('Block10.model_LIST');
FOR vAClist in cAClist loop
-- add_list_element('OP_EVENT_BUTTON.AC_LIST', i,vAClist.item_code,null);
add_list_element('block10.model_LIST', i,vAClist.pdt_code,null);
end loop;
END;
Upd-mod: Add code tags.
[Updated on: Sun, 05 March 2006 22:21] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
