OraFAQ Forum: Forms » list item becomes inactive after using once

Home » Developer & Programmer » Forms » list item becomes inactive after using once (oracle 10g)

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

list item becomes inactive after using once [message #572127]

Thu, 06 December 2012 05:23

oraclehi
Messages: 26
Registered: July 2012
Location: India

Junior Member

hi, i have a form having 5 listitems for making selections. once selecting through listitems i am adding this selection into below datablock by a ok buttonand saving it into database by a ok button. as i made one selection and press ok buttton it's working fine but after this when i want one more selection through listitems, listitems becomes inactive. it's not working after one selection. my coding on ok button is like this:

begin
		
select distinct lcode into	lcode_ss from vac_view where locality=:vac_view.locality;
 select distinct hid into	hid_ss from vac_clr_vu where vr_no=:vac_view.vr_no;

	       :prop_temp.vr_no :=:vac_view.vr_no;
	       :prop_temp.qtr_type :=:vac_view.qtr_type;
	       :prop_temp.locality :=:vac_view.locality;
		:prop_temp.sector :=:vac_view.sector;
		:prop_temp.block :=:vac_view.block;
		:prop_temp.qtrno :=:vac_view.qtrno;
		:prop_temp.floor := :vac_view.floor;
		:prop_temp.regno:=:prop_temp_1.regno;
		:prop_temp.dor:=:prop_temp_1.dor;
		:prop_temp.bpay:=:prop_temp_1.bpay;
		:prop_temp.name:=:prop_temp_1.name;
	        :prop_temp.gpay	:=:control1.gpay1;
		:prop_temp.lcode:=lcode_ss;
		:prop_temp.hid:=hid_ss;
		:prop_temp.qtr_type := :control.qtr_type;
		:prop_temp.wait_no :=1;
		:prop_temp.alt_catg:= :control.alt_catg;
	
			commit;
		last_record;
		next_record;

		
		
clear_list('vac_view.locality');
clear_list('vac_view.qtr_type');
clear_list('vac_view.sector');
clear_list('vac_view.block');
clear_list('vac_view.qtrno');
clear_list('prop_temp.regno');
:vac_view.vr_no:= null;
:vac_view.floor:=null;
:vac_view.vr_no:=null;
:prop_temp_1.name :=null;
:prop_temp_1.dop:=null;
:prop_temp_1.dor:=null;
:prop_temp_1.bpay:=null;
:control1.gpay1:=null;
:prop_temp.wait_no:=null;
:prop_temp.alt_pool:=null;
:prop_temp.catg:=null;

may be it's all because of code: clear_list('vac_view.locality'); .........
but i have to put this as i want to make clear all listitems after making each selections.

waiting for your help.... Smile