Home » Developer & Programmer » Forms » list item becomes inactive after first selection (oracle 10g)
list item becomes inactive after first selection [message #564649] Mon, 27 August 2012 06:28
oraclehi
Messages: 41
Registered: July 2012
Location: India
Member
i faced this problem many times while working with list_items. whenever i use clear_list('') in when list changed trigger then the all other list_items which i have to select after this becomes inactive. i don't know how to deal with this problem
declare
	type_recgrp recordgroup;
	loc_recgrp recordgroup;		
	st number;
	status number;
	qry varchar2(200);	
begin
		
	clear_list('control.locality');
	clear_list('control.sector');
	clear_list('control.block');
	clear_list('control.qtrno');
	clear_list('control.hid');
	
	:control.locality:='';
	:control.sector:='';
	:control.block:='';
	:control.qtrno:='';
	:control.hid:='';
	:control.regno:='';
	
	go_item('control.locality');
	


	--set_item_property('pb_ok',enabled,property_false);						
	
	qry:='select distinct qtr_type,qtr_type from house,occupant where house.hid=occupant.hid 
	      and occupant.occ_status=:parameter.occ_sts order by 1 ';
--	message (qry);
  type_recgrp:=create_group_from_query('type_recgrp',qry);	
		if not id_null(type_recgrp) then
			st:=populate_group(type_recgrp);
			clear_list('control.type');
			populate_list('control.type',type_recgrp);			
		end if;			
		delete_group(type_recgrp);		
end;
Previous Topic: connecting winscp
Next Topic: dynamic record group
Goto Forum:
  


Current Time: Fri Jul 05 22:13:53 CDT 2024