I'm trying to manipulate the values in a query, by selecting a money value and
replacing it with a formated value.
QuerySetCell(qryTest,"MONEYVALUE",LSCurrencyFormat(MONEYVALUE,'none'),currentrow);
Original value: 123.45
Replace value: 123,45
But when I insert the new formated value, sometimes the value converts to a
totally different value.
After some research I found that if a value had descimal number 12 or less the
value changed from 427,08 to -537787, but for decimal value lager than 12 there
was no problem.
Dump of query before manipulation
FLOATVALUE MONEYVALUE
1 427.05 427.0500
2 427.06 427.0600
3 427.07 427.0700
4 427.08 427.0800
5 427.09 427.0900
6 427.1 427.1000
7 427.11 427.1100
8 427.12 427.1200
9 427.13 427.1300
10 427.14 427.1400
11 427.15 427.1500
12 427.16 427.1600
13 427.17 427.1700
14 427.18 427.1800
Dump of query after manipulation
FLOATVALUE MONEYVALUE
1 -537879 -537879
2 -537848 -537848
3 -537818 -537818
4 -537787 -537787
5 -537756 -537756
6 -537726 -537726
7 -537695 -537695
8 -537665 -537665
9 427,13 427,13
10 427,14 427,14
11 427,15 427,15
12 427,16 427,16
13 427,17 427,17
14 427,18 427,18
What is the reason for this problem?
Please help me :)
Best regards
Frode
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241911
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
