Order by non-base table item in Forms 4.5
From: Scott Haas <haas_at_scpa.sri.com>
Date: Tue, 14 Sep 1999 09:14:55 -0400
Message-ID: <37DE4A4E.801CE125_at_scpa.sri.com>
[Quoted] [Quoted] Is there a way to order by a non-base table item ? This non-table item [Quoted] 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 ?
Date: Tue, 14 Sep 1999 09:14:55 -0400
Message-ID: <37DE4A4E.801CE125_at_scpa.sri.com>
[Quoted] [Quoted] Is there a way to order by a non-base table item ? This non-table item [Quoted] 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 - 15:14:55 CEST