Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TRANFORM() Behavior ... changed from SP1 ???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00616533
Message ID:
00616626
Vues:
30
>>>>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) && Displays 10.2
>>? TRANSFORM(10.20) && Displays 10.20
>>SET DECIMALS TO 1
>>? TRANSFORM(10.20) && Displays 10.20
>
>
>It's not by design because it doesn't work this way in VFP 6. Try in VFP 6.
? TRANSFORM(10.2) && Displays 10.2
>? TRANSFORM(10.20) && Displays 10.2
>SET DECIMALS TO 1
>? TRANSFORM(10.20) && Displays 10.2
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform