| List element changed not selected [message #86593] |
Tue, 12 October 2004 23:32 |
aditya gangadharam
Messages: 15
Registered: September 2004
|
Junior Member |
|
|
hi,
thanks for help,
i am using a listbox with the poplist as its property and in the WHEN_NEW_FORM_INSTANCE i have written the following code:
declare
numdeptno deptmast.deptno%type;
cursor numdeptnoent is select deptno dn from deptmast order by deptno;
lst_index number := 0;
begin
--set_item_property('deptmaster.deptno', displayed, property_false);
clear_form(no_validate);
for i in numdeptnoent
-- open numdeptnoent;
loop
--fetch numdeptnoent into :deptmaster.lstdeptno;
lst_index := lst_index + 1;
--message('Items added to list box');
add_list_element('deptmaster.lstdeptno',lst_index,to_char(i.dn),i.dn);
--exit when numdeptnoent%notfound;
end loop;
--close numdeptnoent;
end;
and in the lstdeptno( this is the list item name in the form deptmast) in the event of WHEN_LIST_CHANGED i wrote the following code:
declare
cursor f_rec is select * from deptmast where deptno = :deptmaster.lstdeptno;
begin
next_item;
open f_rec;
fetch f_rec into
:deptmaster.lstdeptno,
:deptmaster.deptname;
close f_rec;
end;
here i want to see the deptmast details in the respective controls on selecting the deptno in the list box.
but it is not showing the details.
please help me.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
