Home » Developer & Programmer » Forms » hierarchical tree
hierarchical tree [message #81239] Sat, 25 January 2003 00:51 Go to next message
Jameel Ahmed
Messages: 10
Registered: January 2003
Junior Member
can any body tell me how can add tree items from a data base at run time. i use ftree.add_tree_data but it populates the data again n again when ever i click the tree node.
Re: hierarchical tree [message #81277 is a reply to message #81239] Wed, 29 January 2003 01:12 Go to previous message
Joyjeet
Messages: 23
Registered: January 2003
Junior Member
In yr case using record_group (RG) will be very handy. Write the hierarchical query having output 5 cols.,which are essential to define a tree. Populate the group in yr desired event and populate the tree with the help of the record group.
Example:
the RG query can be :
select decode(level,1,1,-1),
level,
LVL_NAME,
Null,
CALLED_MOD
from menu
connect by prior LVL_NO = LVL_NODE
start with LVL_NODE = 0;

based on the table:
LVL_NO NUMBER(5)
LVL_NAME VARCHAR2(50)
LVL_NODE NUMBER(5)
DESCRIPTION VARCHAR2(500)
CALLED_MOD VARCHAR2(30)

then at yr desired event trigger :

dummy := populate_group('menu_Tree');
ftree.populate_tree('menu.menu_tree');

menu_tree is our tree item whose record source is
RG-menu_Tree.

JD.
Previous Topic: Re: Forms60_path
Next Topic: setting up a test database on my home pc
Goto Forum:
  


Current Time: Thu Mar 28 09:56:00 CDT 2024