| hierarchical tree [message #81239] |
Sat, 25 January 2003 00:51  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
