About forms 6i [message #79493] |
Mon, 17 June 2002 04:35 |
Sukhoi
Messages: 4 Registered: June 2002
|
Junior Member |
|
|
Hello Everybody,
Can u please help me out in the development of the treeview in forms 6i. I like to need step by step
Thanks in advance
|
|
|
Re: About forms 6i [message #79507 is a reply to message #79493] |
Tue, 18 June 2002 06:33 |
Subhash
Messages: 105 Registered: October 2001
|
Senior Member |
|
|
Place the Tree Item on canvas. Ensure that no other items are there in the same block
Go to Properties of the Tree Item . In Data Query Write this code. Select -1,level,job,Null,job from emp start with empno=7839 connect by mgr=prior empno .
Use Ftree.Populate_Tree(TREE NAME) for populating the Hiearchical tree .
The first parameter in the Select statement denotes whether it is a collapsed ,expanded or normail node.
1 - Expanded
0 - Normal
-1 - Collapsed.
The second parameter is the level
The third is the value to be displayed
The fourth is the Icon Name
The fifth is the value returning
- Regards
|
|
|
Re: About forms 6i [message #79553 is a reply to message #79493] |
Fri, 21 June 2002 02:02 |
Sukhoi
Messages: 4 Registered: June 2002
|
Junior Member |
|
|
Thanxs for your help it worked well. But i tried to display the empno from emp table but i was pretty much succesful in doing that but except that the tree cannot be minimized.the query i used was
select 0,0,'Emloyee Number',null,'Employee Number' from emp
union
Select 0,1,to_char(empno),Null,to_char(empno) from emp
warm wishes
So if you could able to help me
|
|
|
|