Re: Order by

Thanks, the function idea worked great in my form.

I didn't know you could put functions on the ORDER_BY property of the block.

Thanks much!

Ken.

"Mike Dwyer" <dwyermj_at_co,larimer.co.us> wrote in message news:y0DN4.27$Yi.5622_at_wdc-read-01.qwest.net...
> If the view approach does not work...
> Create a stored function that queries the description table using the key
 as
> a passed parameter. In the form, use this procedure in the ORDER BY
> property, providing the item key field name as the parameter.
>
> You can find an example of this on metalink; search for "How to order by a
> non database item in a block." Or drop me a note and I'll see if I can
 help.
>
> "Robin Quasebarth" <quasebarth_robin_r_at_solarturbines.com> wrote in message
> news:3906091C.66E3A78A_at_solarturbines.com...
> > You might need to use a view with that element instead of a table. rq
> >
> > Ken Halsted wrote:
> > >
> > > Just wondering how I could order by a display item in a form. I have
 a
 form
> > > that lists items (item number, description, etc).
> > >
> > > If Item Description is a DISPLAY item coming from another table not in
 this
> > > form, how can I choose to order by the description?
> > >
> > > Is it possible?
> > >
> > > Thanks,
> > >
> > > Ken.
>
>
Received on Wed Apr 26 2000 - 00:00:00 CEST