INDEX ON STR(99999999 - VAL(cAuktCID)) + STR(99999999 - VAL(cObjectCID)) ;
+ STR(99999999 - nOffer) + cID TAG MyTag


The DESCENDING keyword applies to the entire index, not just a particular field.

>Can anyone help me with the right syntax for an indexkey that sort the following data:
>
>
>cAuktCID cObjectCID nOffer CID
>" 21" " 83" 567.00 " 129"
>" 21" " 83" 567.00 " 126"
>" 21" " 83" 567.00 " 128"
>" 21" " 83" 650.00 " 125"
>
>
>I want it to look like this when it's indexed.
>
> Desc Desc Desc Asce
>" 21" " 83" 650.00 " 125"
>" 21" " 83" 567.00 " 126"
>" 21" " 83" 567.00 " 128"
>" 21" " 83" 567.00 " 129"
>
>I have tried with this, but i does not work:
>cAuktCID + cObjectCID + STR(nOffer) + STR(VAL(cid)*-1) DESCENDING
>
>The 3 first columns gets sorted right but CID-column always
>ends up in descending order although i use -1 in the calculation.
>What am i missing here ?