That did the trick, thanks a million
Nick Patel
>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