Re: Order by non-base table item in Forms 4.5
From: Prasad Pelala <ppel_at_gwl.com>
Date: Tue, 14 Sep 1999 16:10:56 -0600
Message-ID: <37DEC7F0.C9F7C4AF_at_gwl.com>
Date: Tue, 14 Sep 1999 16:10:56 -0600
Message-ID: <37DEC7F0.C9F7C4AF_at_gwl.com>
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 Wed Sep 15 1999 - 00:10:56 CEST