Home » Developer & Programmer » Forms » dynamic list box
dynamic list box [message #231707] Wed, 18 April 2007 04:00 Go to next message
canny
Messages: 10
Registered: December 2006
Junior Member
hi all
here canny struggling with dynamic list box generation
my requirement is like this
i have one database text item 'er_engg_reg_no' and list box 'newlist' populated by query
when i type some value in the text item 'er_engg_reg_no' , the list box should display that number alone(duplication allowed)
can anyone please help me.....check the coding....

trigger:when new item instance at block level

declare
	group_name varchar2(20):='new';
	group_id recordgroup;
	query_ok number;
	list_id item:=find_item('engg_req.newlist');
	reg_no number(6);
begin
	group_id:=find_group(group_name);
	reg_no:=:engg_req.newtext;
	
	
	if id_null(group_id) then
		 group_id:=create_group_from_query(group_name,'select to_char(er_engg_reg_no),to_char(er_engg_reg_no) from engg_req
				where er_engg_reg_no=reg_no');
    	end if;
	query_ok:=populate_group(group_id);
	clear_list(list_id);
	populate_list(list_id,group_id);
	
end;

Upd-mod: Added code tags.

[Updated on: Thu, 19 April 2007 21:20] by Moderator

Report message to a moderator

Re: dynamic list box [message #232238 is a reply to message #231707] Thu, 19 April 2007 21:21 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What is the error that you are getting?

Have you searched this forum for other people's attempts when they have used 'create_group_from_query'?

David
Previous Topic: how to invoke color and font window.?
Next Topic: Execute Query show me just the first one row of table at begin.
Goto Forum:
  


Current Time: Thu Sep 26 22:46:05 CDT 2024