Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TRANSFORM() and decimal places
Message
From
25/11/2003 21:19:50
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00853488
Message ID:
00853566
Views:
17
>Can anyone tell me exactly when TRANSFORM() started returning decimal places in .DLLs and not in the command window?
>
>All of a sudden clients are calling with issues on our VFP8 SP1 app where TRANSFORM(1234567890123456) returns ***********.**** in the .DLL. We've verified that changing the code to ALLTRIM(STR(1234567890123456,16)) fixes the issue. Not sure why some numbers return and other numbers return "*"s.
>
>We just need to verify that there is no alternative but to change TRANSFORM(x) to ALLTRIM(STR(x,16)) in about 1,000 places.

Hi Mike,

What do you have for SET DECIMALS and SET FIXED? Both of these are scoped to the data session. Try this:
SET DECIMALS TO 
SET FIXED OFF
? TRANSFORM(1234567890123456)
SET DECIMALS TO 4
SET FIXED ON
? TRANSFORM(1234567890123456)
The question remains though, why the sudden change in the behaivor of your app. I'm sure these two haven't changed in years.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform