>>>>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".
Yep, we already discussed this problem about month or two ago. I sent a private message to Garret asking him to check the thread, but he didn't confirm, what it was a behavior change.
Hopefully, this time MS will look into this problem.
If it's not broken, fix it until it is.
My Blog