dynamic list box [message #231707] |
Wed, 18 April 2007 04:00 |
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 |
|
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
|
|
|