Re: Help!! order by on non base table items

Daryl Collins wrote:
>
> snip
>
> Mark wrote:
> >
> > Hi there...
> >
> > Anyone got any clever methods of allowing forms 4.5 to include a non
> > base table item in a base table block in the ORDER BY clause?
> >
>
> Try this
>
> create a function in database pass it the id and use the function in the
> order by clause - its just a thought ive never tried it.
>

sounds good, although, beware, you cant do 'group by' on a function

back in V6 Forms V3, i got around this problem by building the order by in the pre-query trigger and using the # feature imbed it in the query.

steve. Received on Fri May 16 1997 - 00:00:00 CEST