Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numer of Decimal Places
Message
 
To
09/11/2004 05:50:02
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
00956861
Message ID:
00959480
Views:
13
This message has been marked as a message which has helped to the initial question of the thread.
That depends of SET("Decimals"), You must change Your current SET DECIMALS TO so the TRANSFORM can hadle it corectly i.e.:
old_decimals = SET("DECIMALS")
SET DECIMALS TO 5 && or any other number bigger then 2

REPORT FORM... && Here You have TRANSFORM(123.456,'999.999') 

SET DECIMALS TO &old_decimals && Restore Your default decimals number
>Got a small problem with TRANSFORM. When I use the format, it is rounding up the last digit. for example, TRANSFORM(123.456) returns 123.456 and TRANSFORM(123.456,'999.999') returns 123.460
>Any work around for this?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform