Home » Developer & Programmer » Forms » tree list help me experts.
tree list help me experts. [message #86786] Sun, 31 October 2004 18:41 Go to next message
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 Go to previous messageGo to next message
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 #246115 is a reply to message #86786] Wed, 20 June 2007 00:48 Go to previous messageGo to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

Hi Aarti,
I worked with the instructions given by you.
1)I truly could not follow to create hierarchy.
2)could you please correct me in my fmb below as attachment.

thanks,
Surya
  • Attachment: navigator.fmb
    (Size: 44.00KB, Downloaded 166 times)
Re: tree list help me experts. [message #246811 is a reply to message #86786] Fri, 22 June 2007 01:27 Go to previous messageGo to next message
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 .
Re: tree list help me experts. [message #246839 is a reply to message #86786] Fri, 22 June 2007 03:19 Go to previous message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

H folks,
how do we call the form/fmx file when clicked in navigator?
Thanks in advance,
Surya
Previous Topic: Please Help......Using Cursor for picking up values at runtime
Next Topic: Forms .fmx size
Goto Forum:
  


Current Time: Tue Dec 06 06:31:36 CST 2016

Total time taken to generate the page: 0.08647 seconds