>>>Rich,
>>>
>>>Are you using VFP6? Transform works for VFP7...see
Re: LEN() for numeric expresions Thread #
716929 Message #
716960 and surrounding discussion.
>>
>>TRANSFORM() doesn't work with trailing 0's. Not in VFP8, anyways.
>>
>
>Are you saying it changed between version 7 and 8? Or are you saying Larry Miller is wrong? < gd&r >
>
>BTW, I don't have 7, or 8 (yet).
It's not trailing 0's, it's values that end up as whole numbers with insignificant 0's. Doesn't work in VFP7, either.
n=1.23450
? TRANSFORM(n)
1.23450
n=20.000
? TRANSFORM(n)
20
So I guess that makes Larry wrong. < s >