>I type - USE Mytable - SET ORDER TO Myfield - COPY TO ARRAY Myarray FIELD Myfield - Myarray is now a list of numbers from a numeric field in ascending order. At this point I cannot seem to get the syntax correct for the next command, which is an ASORT( ) that will reverse the sort order to descending. How do I refer to the first element without adding an extra comma to the ASORT( )?
Easiest woulde be to redo your method of building the list. Instead of:
USE MyTable
SET ORDER TO MyField
COPY TO ARRAY MyArray FIELD MyField
Why not:
SELECT MyField ;
FROM MyTable ;
TO ARRAY MyArray ;
ORDER BY MyField DESC