|
|
|
|
|
Re: Refresh data in a hierarchical tree [message #182467 is a reply to message #182466] |
Sat, 15 July 2006 03:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ingalesd
Messages: 10 Registered: June 2006 Location: Mumbai
|
Junior Member |
![ingalesd%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
try this DECLARE
htree ITEM;
v_ignore NUMBER;
rg_emps RECORDGROUP;
vquery varchar(2000);
BEGIN
:system.message_level := '25';
htree := Find_Item('app.trapp');
rg_emps := Find_Group('emps');
IF NOT Id_Null(rg_emps) THEN
DELETE_GROUP(rg_emps);
END IF;
rg_emps := Create_Group_From_Query('rg_emps',
'select 1, level, app_name, decode(frm_rep_flag,''F'',''form'',''R'',''report'',''O'',''other''), app_no ' ||
'from app_master ' ||
'connect by prior app_no = parent ' ||
'start with parent is null');
v_ignore := Populate_Group(rg_emps);
Ftree.Set_Tree_Property(htree, Ftree.RECORD_GROUP, rg_emps);
end;
[Updated on: Sun, 16 July 2006 01:35] by Moderator Report message to a moderator
|
|
|