>>Hi,
>>
>>I have a View that I need to index on a character field (type of document) in ascending order and documents of the same type must be indexed on a date field (date of the document) in descending order. In VFP 5.0 I was using INDEX ON tp_documento + STR({31/12/2100} - dt_documento, 5) TAG DATA and it was working fine. After upgradind to VFP 6.0 I needed to change to {^2100-12-31} and now I get a message that says :
>>
>>Index does not match the table. Delete the index file and re-create the index (Error 114)
>>
>>Any help ?
>>
>>Regards,
>
>USE DTOS to convert your date to a date setting independent string.
Erik,
He wants the document type in ascending order and the date in descending order. So he first makes the substraction between a date in the distant future and the document date and obtains a numeral that he converts to string after. That's OK for me, and works well under VFP5.
José