>Greetings
>I am attempting to create an index that is both ascending and descending components.
>
>Vendor has to be ascending, PO has to be descending. I tried variations of:
>
>INDEX on vendcode ASCENDING + ponum descending tag vendpo
>INDEX on vendcode + ponum descending tag vendpo
>INDEX on ascending(vendcode) + DESCENDING(ponum) tag vendpo
>SET ORDER TO VENDPO vendcode ASCENDING ponum descendng
>SET ORDER TO VENDPO vendcode, ASCENDING ponum descendng
>
>
>This should be a no brainer, but I can't get the syntax correct.
>
>Any Ideas out there???
>
>thanks, Vince
What field types have you got?