forms9 application

Populating list items  proj_search_criteria.assigned_department_id  from table departments  dynamically

proj_search_criteria.assigned_department_id   when_ mouse_click trigger as follows  :

 

declare

rg_list_id recordgroup;

rg_name varchar2(20) :=’rg_list’;

ret_code number;

v_select varchar2(300);

begin

v_select:=’select  department_id,department_id from departments order by 2′;

rg_list_id :=find_group(rg_name);

if not id_null(rg_list_id) then

delete_group(rg_list_id);

end if;

rg_list_id :=create_group_from_query(rg_name,v_select);

ret_code :=populate_group(rg_list_id);

populate_list(‘proj_search_criteria.assigned_department_id’,’rg_list’);

end;  

Advertisements
此条目发表在未分类分类目录。将固定链接加入收藏夹。

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s