Home » Developer & Programmer » Forms » trigger event problem for dynamic list item  () 2 Votes
trigger event problem for dynamic list item [message #207898] Thu, 07 December 2006 04:53 Go to next message
shohagttl
Messages: 1
Registered: December 2006
Junior Member
Hi,
i wrote the following code for dynamic list item(combo box) at when_new_form_instance trigger.it works usually at first time when i open the form but its not my desired. i want it when i will save the record after the item will show at combo box at run time.please help me for the exact trigger event which will perform at run time
declare
   rg_name   varchar2 (40) := 'dept_rec';
   status    number;
   rgroup    recordgroup;
Begin
   rgroup  :=
      create_group_from_query
              (rg_name,
               'select to_char(deptno) deptno,to_char(deptno) deptno from dept');
   status  := populate_group (rgroup);
   clear_list ('deptno');
   populate_list ('deptno', rgroup);
end;

Thank u
Mahbub Shohag

Upd-Mod: Please use the 'code' tags and format your code.

[Updated on: Thu, 07 December 2006 16:49] by Moderator

Report message to a moderator

Re: trigger event problem for dynamic list item [message #208012 is a reply to message #207898] Thu, 07 December 2006 16:57 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Why are you using a dynamic record group with static 'select' statement? A static record group would be just as good. If you intend creating a record group more than once you need to delete the previous copy. Search this forum for 'create_group_from_query delete_group'.

David
Previous Topic: FRM-40735
Next Topic: Forms Run time
Goto Forum:
  


Current Time: Fri Sep 20 15:35:38 CDT 2024