General information
Category:
Coding, syntax & commands
Title:
Need to Combine Ascending and Descending Indexes
Greetings!
I need to set up an index to sort records using a mix of ascending and descending orders, using character fields.
I recall this could be done using the SYS(15) function ("included for backward compatibility"). I've done it before, but now do not remember how! Apparently, the list of fields in the sort order would include something like "SYS(15, "ZYXW...", field)". This would cause the field to be sorted in descending order by substituting each character--a "Z" for an "A", "Y" for "B", and so forth.
However, it does not work. Does anyone else know how to do this?
Thanks!
Michael Reynolds
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only