Home » Developer & Programmer » Forms » Refresh data in a hierarchical tree
icon4.gif  Refresh data in a hierarchical tree [message #182401] Fri, 14 July 2006 10:39 Go to next message
satishachar
Messages: 17
Registered: July 2006
Location: Mumbai
Junior Member

I have created a tree control for menu.
This control will give data about the access /revoke status of the applications to be handled for a particular user.

When i doubleclick the node the data will give Y as access to that particular for the user.

I want to refresh the data on the same tree when i give access/revoke permissions for the applications for that user.

can someone give solutions for this.
icon10.gif  Re: Refresh data in a hierarchical tree [message #182448 is a reply to message #182401] Fri, 14 July 2006 23:32 Go to previous messageGo to next message
ingalesd
Messages: 10
Registered: June 2006
Location: Mumbai
Junior Member

Have u populated tree from query?

if so then update the backend table and use

set_tree_property to repopulate the tree

also u can use

set_tree_node_property to set icons and label properties to identify weather the program is accecible or not

regards

shantaram




Re: Refresh data in a hierarchical tree [message #182457 is a reply to message #182448] Sat, 15 July 2006 01:56 Go to previous messageGo to next message
satishachar
Messages: 17
Registered: July 2006
Location: Mumbai
Junior Member

We have populated the tree

also we are updating the backend table.

We used the populate_tree built-in as well

but it does not give the right result


why is this.
Re: Refresh data in a hierarchical tree [message #182463 is a reply to message #182457] Sat, 15 July 2006 03:12 Go to previous messageGo to next message
ingalesd
Messages: 10
Registered: June 2006
Location: Mumbai
Junior Member

use ftree.set_tree_property
in place of populate_tree

the package name ftree is must if ur using forms 6 or 6i

regards
shantaram
Re: Refresh data in a hierarchical tree [message #182466 is a reply to message #182401] Sat, 15 July 2006 03:42 Go to previous messageGo to next message
satishachar
Messages: 17
Registered: July 2006
Location: Mumbai
Junior Member

can u give some coding skills for this

i tried the ftree.set_node_property
but still does not work

it is urgent.pls help
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
ingalesd
Messages: 10
Registered: June 2006
Location: Mumbai
Junior Member

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

Previous Topic: Requests submitted from form cannot be found
Next Topic: Error-FRM-40301
Goto Forum:
  


Current Time: Fri Sep 20 08:24:30 CDT 2024