| Hiearchical tree [message #79162] |
Wed, 08 May 2002 01:51  |
Thomas J Kakkassery
Messages: 3
Registered: May 2002
|
Junior Member |
|
|
Hi,
Can any one help me to populate a hiearchical tree in forms-6i.My sql query is as follows scott/tiger
select lpad(' ',4*(level-1)) || job from emp
start with empno=7839
connect by mgr=prior empno;
In the backend it is giving. but when i used it in forms-6i (through query_text or record_group).
thanking you in advance.
Thomas.
|
|
|
|
| Re: Hiearchical tree [message #79163 is a reply to message #79162] |
Wed, 08 May 2002 02:31  |
Subhash
Messages: 105
Registered: October 2001
|
Senior Member |
|
|
Hi,
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 .
Then 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
Hope this will help
Regards
Subhash
|
|
|
|
| Re: Hiearchical tree [message #79796 is a reply to message #79162] |
Fri, 12 July 2002 21:05 |
Subhash
Messages: 105
Registered: October 2001
|
Senior Member |
|
|
Hi Subhash,
Many many thanks to you ,
It is working very fine. If you can give reference of books for this, I will be more happy.
waitin for your reply
thanking you agian
regards
RANA
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
