Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency calculations. Bug?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Currency calculations. Bug?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01505515
Message ID:
01505515
Views:
113
It is expected that result of calculations may be slightly different depending on the initial precision, but the difference in tens units?
Anyone can shed light on it?
* Tested in versions VFP5, VFP7, VFP 9 and VFP 9 Sp1
CLEAR
CLOSE tables all
CREATE CURSOR testcrs (fldn N(12,4), fldcur Y) 
ln=300000

INSERT INTO testcrs VALUES (ln,ln)
n1=43.05
n2=44.06

?"Variable:         ", n2/n1 * ln, ln * n2/n1		&& ~same
?"Numeric field:    ", n2/n1 * fldn, fldn * n2/n1	&& ~same

?"Currency field:   ", n2/n1 * fldcur, fldcur * n2/n1     && 307050.0000,        307038.3275        different results ?!
?"Currency2Numeric: ", n2/n1 * MTON(fldcur), MTON(fldcur) * n2/n1  && ~same
Thanks in advance

Yuri Rubinov
Next
Reply
Map
View

Click here to load this message in the networking platform