>>>I want to index a file on descending order of fields 1 and 2 but within that on ascending oder of fields 3 - how can I do this?
>>>
>>>I have tried this but it doesn't work
>>>
>>>index on dupkey+codex DESCENDING, COPYNO ASCENDING TAG docky
>>
>>You could use SQL SELECT and ORDER BY instead.
>
>Not keen on that - I think I will use the sort function which does work if it can't be done using the index functio

Sort is slow and outdated. It creates a physical file too. I'd go with SQL to a cursor.