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

Scott,

To order by a non-base table item, you can also specify your own function. Similar to using 'decode', you can pass values and the function's return value will then order the block. This is an excellent way to sequence by the alphanumeric description of a numeric code, for example. The principles are well explained in an article called 'Functional Magic', written by John Lennon and located at
http://members.aol.com/jomarlen2/oraclesh.html

Scott Haas wrote in message <37DE4A4E.801CE125_at_scpa.sri.com>...
>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 - 23:09:30 CDT