Re: Perform data ordering

Quoting Mark L Trotter... } } I am looking for a way to force perform to list the current list } returned from a query to a particular order. For instance, if I query } on the entry date for a specific range, I still want the rows displayed } in lastname, firstname order. Can this be done? } I am using SQL 4.1 on the 5.0 OnLine engine on an HP9000/832 running } HPUX 8.0. } I have found that creating a clustered index on the fields to be sorted usually (but not always) works. In perform, there is no full proof way of doing an ORDER BY. DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com