Thanks Glenn.
>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
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"