>>>>I have this common lines:
>>>>
>>>>CREATE CURSOR test(Num NUMERIC(10,2))
>>>>APPEND BLANK
>>>>REPLACE Num WITH 10.2
>>>>
>>>>
>>>>In VFP 6.0 if i issue this command:
>>>>? TRAN(Num) i have this result 10.2
>>>>
>>>>In VFP 7.0 SP1, witnh the same command i have this result 10.20 .... i supect that this behavior is changed from SP1 ... anyone can confirm this supect ? .. and is a Feauture or is an Introduced Bug ??
>>>>
>>>>Emanuele
>>>
>>>I can confirm that transform() function bechavior changed in VFP 7. Contrary to what help says it doesn't strip trailing zeros from the decimal portion anymore. I think it's a bug.
>>
>>I think this is by design. Try
? TRANSFORM(10.2)
>>? TRANSFORM(10.20)
>>SET DECIMALS TO 1
>>? TRANSFORM(10.20)
>
>
>It's not by design because it doesn't work this way in VFP 6. Try in VFP 6.
? TRANSFORM(10.2)
>? TRANSFORM(10.20)
>SET DECIMALS TO 1
>? TRANSFORM(10.20)
The VFP 6/7 help also states that "Trailing zeros are removed from the decimal portion of a numeric value".
What I'm saying, Sergey, is that the change was by design in 7.0. What it did in 6.0 is different.
George
Ubi caritas et amor, deus ibi est