Re: Hierarchical trees in Forms 6.0

I hope it helps the enclose is an example of automatcly populating tree from query on the emp table

    rg_emps := create_group_from_query('EMPS',

             'select 1, level, ename, NULL, to_char(empno) ' ||
             'from emp '                                     ||
             'connect by prior empno = mgr '                 ||
             'start with job = ''PRESIDENT''');

    v_ignore := populate_group(rg_emps);     ftree.set_tree_property('navigator.nav_display', ftree.record_group, rg_emps);
Good luck,
Dudy

Damian Lewandowski wrote:

> Creating trees this way is little crazy. I have to sort leaves in
> hierarchical tree. But i see it's maybe impossible to do it automaticaly
> - clause ORDER BY makes this tree a total mess. Possibly trees are
> stupid designed (my opinion).
> Damian
>
> kaiserrj_at_my-deja.com napisa³:
> >
> > The format of the trees underlying data is listed
> > in help, although finding it's a little obscure.
> >
> > In Help | Form Builder Help Topics | Index
> > select hierarchical trees / creating
> > select Related Topics
> > select Format of data used to populate a hierarchical tree
> >
> > Good luck, Rich
> >
> > In article <385F920D.9C3C8FE4_at_comarch.pl>,
> > Damian Lewandowski <Damian.Lewandowski_at_comarch.pl> wrote:
> > > Hi everybody,
> > > i need some information about hierarchical trees - especially, how
> > to
> > > construct query that builds such tree. What should i use in select
> > > statement, e.g.
> > >
> > > select [what here????] --- any special format or something ????
> > > from x ^^^^^^^^^^^^^ | i know
> > > connect by .... | what should i write
> > > start with.... | here ;)
> > >
> > > Please Heeeelp
> > > damian
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Dec 23 1999 - 09:35:34 CET