Home » Developer & Programmer » Forms » list item becomes inactive after using once (oracle 10g)
list item becomes inactive after using once [message #572127] Thu, 06 December 2012 05:23 Go to next message
oraclehi
Messages: 40
Registered: July 2012
Location: India
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
Re: list item becomes inactive after using once [message #572132 is a reply to message #572127] Thu, 06 December 2012 06:39 Go to previous message
cookiemonster
Messages: 10841
Registered: September 2008
Location: Rainy Manchester
Senior Member
Clear_list removes the list of values the list item contains.
To get rid of the currently selected value just set the list item to null.
Previous Topic: sql loader with forms
Next Topic: File Access Issues
Goto Forum:
  


Current Time: Tue Jul 22 06:24:41 CDT 2014

Total time taken to generate the page: 0.10691 seconds