Re: Order by non-base table item in Forms 4.5

It depends on when you calculate the "calculated field".

If your calculated field is based on the values from the base table items, you can use DECODE in the order by as ORDER BY decode(user_entered_paramter, 'A', ((item1*item2)/100),

                                          'B', ((item2/item2)*100) ....

Prasad.

Scott Haas wrote:
>
> Is there a way to order by a non-base table item ? This non-table item
> is calculated based on criteria that a user enters prior to querying the
> database. I want to be able to order the records based on this
> calculated field. Would I have to put the retrieved records with the
> calculated field into a temporary table and then perform the order by or
> is there a more simple way to solve this ?
>
> TIA,
> Scott
Received on Tue Sep 14 1999 - 17:10:56 CDT