Re: URGENT!!! Forms questions: HTREE & CURSOR

sorry for my bad english :(

order by: i need "sorted" cursor to create tree in rigth way; i have some data which could be sorted by creation_date or by ID and my; i have also "check box" to provide rigth threat order example: cursor XXX is select ID,name from table1 ORDER BY :CHECK_BOX_VALUE; i hope it is understandable now?!

htree: can somebody help me with that? how to make it EXPANDED by default?

AR

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3DFD85E0.B5984035_at_exesolutions.com...
> AR wrote:
>
> > Hello!
> >
> > i have two eazy (I hope so)..
> >
> > 1. i declare cursor in my "PL/SQL trigger" and I put "order by" in the
 end
> > of it; IT DOESN'T WORK! i think it just ignore it.
> > So what shoul i do to sort my data in cursor?
> >
> > 2. i have HTREE, can i built it to be expended? there is a option
> > (EXPANDED_NODE), but it doesn't work! did i do something wrong or is
 that a
> > bug?!
> > and something more here: i have HTREE with muliple "roots" with
 differnet
> > names: how can drop that tree in once?
> >
> > tnx for advices,
> > AR
>
> Could you provide less useful information?
>
> Order By works ... but what in the world is SQL statement with Order By
 doing
> in a trigger?
>
> Why don't you provide some explanation, verion information, code sample,
 etc.
> and then ask for help.
>
> And please only post to a single usenet group in the future.
>
> Daniel Morgan
>
Received on Mon Dec 16 2002 - 10:53:56 CET