Hi Tracy,
You can also simplify the expression like this:
DTOS(P_DATE)+PADL(PO_INSCO,3)+PO_NAME
because padX functions automatically convert to string.
Glenn
>Thanks Doug. Can't believe I didn't catch that one!
>
>>Hi Tracy.
>>
>>>When I look at index expression for the tag re_tag in the dbc in Stonefield Database Explorer the index expression is:
>>>
>>>DTOC(P_DATE)+PADL(STR(PO_INSCO),3)+PO_NAME
>>
>>VFP 9 no longer supports index expressions of this type. The reason is that DTOC() can give inconsistent results depending on the setting on SET CENTURY -- with that OFF, the result is 8 characters long, but 10 with that being ON. Try using DTOS() instead (of course, you'll have to change any SEEK statements accordingly).
>>
>>Doug