Home » Developer & Programmer » Forms » dynamic list box
dynamic list box [message #231707] Wed, 18 April 2007 04:00 Go to next message
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

	group_name varchar2(20):='new';
	group_id recordgroup;
	query_ok number;
	list_id item:=find_item('engg_req.newlist');
	reg_no number(6);
	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;

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
Messages: 10180
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'?

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: Fri Jul 21 00:09:15 CDT 2017

Total time taken to generate the page: 0.29225 seconds