Try dtos(op_ord_date) instead of the dtoc clause, and tell me if this helps
Jaime
>I have a view that orders the data by following:
>
>
> ORDER BY O_ord_pay.op_vendor, O_ord_pay.op_ord_date
>
>
>I am now trying to create a index that should replicate the above sorted order as follows:
>
>
>INDEX ON op_vendor+dtoc(op_ord_date) TAG (vendorord) ascending
>SET ORDER TO (vendorord) ascending
>
>
>
>When I run the second senerio, the order of data doesn't come out like the view order. What I'm I doing wrong?
>
>Thanks
>Nick Patel
Why do programs stop working correctly as soon as you leave the Fox?