| tree list help me experts. [message #86786] |
Sun, 31 October 2004 18:41  |
shish mate
Messages: 49
Registered: February 2004
|
Member |
|
|
hi boss (form 5)
do u know how to create tree list.
i was tryin to create it by using help file in forms but i dont have commplit help on that some files are missing can u send me thoes files or else give staps involved in tree list creation. i hv attached NAVIGATE.PLL librari to my module what is next step
i tryed to run my form but it gives me some error releated to
navigator.get_tree_name
navigator.To_Index
etc..
pl help me
thanks
ASHish.....
|
|
|
|
| Re: tree list help me experts. [message #86822 is a reply to message #86786] |
Sat, 06 November 2004 22:23  |
Aarti
Messages: 8
Registered: September 2001
|
Junior Member |
|
|
Hi
Creating a tree list is done through Heirarchial tree.
In order to populate the tree properly u need to set the right query.
go to property pallete of the tree and under data query type the query as
E.g. for emp table
select -1,level,ename,null,to_char(empno) from emp
start with mgr is null
connect by prior empno = mgr;
in the above query
a)-1 denotes whether the tree is expandable or not. 1 is to expand to all levels ,0 is one level, -1 is no expand
b)level
c) ename column this is the text that will appear on your tree nodes.
d) icon name i have put null
e) to_char(empno)is the value of the node u want to store.
Note a tree would work only if you are able to create a heirarchy like the emp table so that one can start with where mgr is null and connect the nodes where empno and mgr is same.
the output of this tree will let u know who works under whom from the emp table.
to populate the tree at run time
write trigger when-new-form-instance
DECLARE
ITEM_ID ITEM;
BEGIN
ITEM_ID := FIND_ITEM('tree.htree');
--where htree is the name of tree and tree is the block name
IF NOT ID_NULL(ITEM_ID)THEN
FTREE.POPULATE_TREE(ITEM_ID);
END IF;
END;
i hope this helps u give little understanding of a tree.
|
|
|
|
|
|
| Re: tree list help me experts. [message #246811 is a reply to message #86786] |
Fri, 22 June 2007 01:27 |
mell.gu
Messages: 6
Registered: June 2007
Location: China
|
Junior Member |
|
|
shish mate
pls delete ; from data query in tree propertyp palette
just like below is OK!
select -1,level,ename,null,to_char(empno) from emp start with mgr is null connect by prior empno=mgr
i RUN ok .
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
