Re: Froms 6.0, Hierarchical tree usage help

From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: Fri, 9 Jul 1999 02:05:05 +0200
Message-ID: <J0bh3.3810$d8.6153_at_afrodite.telenet-ops.be>

The tre you want to populate must have more than 1 column (select Name from department only returns 1 column°
Try this sql-statement :

 select  1,        level,
             emp.ename,        'C:\ORANT\FORMS45\DEMOS\ICONS\'||
             DECODE(level,1,'W_KING',
                                        2,'W_QUEEN',
                                        3,'W_KNIGHT',
                                            'W_PAWN')||
            '.ico',                    to_char(empno)from    emp

connect by prior empno = mgr start with JOB = 'PRESIDENT'

!!!(eventually replace the C:\ORANT by your oracle home or another path containing your icons or leave the column null).

The meaning of the different Columns:
Column 1 = state number :1 = expanded node

                                            -1 = colapsed node
                                             0 = leaf node
Column 2 = offset number (the level in the tree)
Column 3 = label varchar (the label of the treenode)

Column 4 = icon varchar2 (null allowed) (the icon of the treenode) Column 5 = value varchar2 (the value bound to the label)

Good luck!

Sean Zhang <sean_at_cnfei.com> schreef in berichtnieuws ZO3h3.2007$Pu4.10292440_at_firenze.visi.net...
> Hi, Everyone,
>
> Could somebody please enlighten me how to use <hierachical tree> items
> in Forms 6.0 (Windows 95 Enviroment)? I followed online instructions
> and created a tree item with a Record group as data source, then I used
> Ftree.populate_tree to try to populate the tree, I always got an error:
> "Frm-47321:data used to populate tree is invalid". The record group
> I used only does a "select Name from department", what could be wrong?
>
>
> Any advises and suggestions are greatly appreciated.
>
>
> Sean Zhang
> mailto:sean_at_cnfei.com
>
>
>
>
>
>
>
>
Received on Fri Jul 09 1999 - 02:05:05 CEST