Icon View Incident Report

Serious Serious
Reported By: Graham Wood
Reported On: 3/27/1999
For: Version 1.13 Build 1
# 392 Saving Currency Values in DBSYS Causes Improper Decimal Places to be Added

If I try to save a value that is of type 'Float' or 'Currency' in the Database System Utility, it automatically adds .00000011 to the value if it has any decimal values. This means that I can't have '2.5'. I always
get something like '2.5000000011'. To reproduce this, just use the BDE Database Transfer Utility to make a DBISAM table from DBDEMOS:Orders.DB. This is why I can't use the Decision Cube component,
because "Sum(Orders."AmountPaid")" is being expected as a currency 'type' but is returning all these decimal places that did not exist in the original Orders.DB. DBISAM will work with the Decision Cube if I manually make all floats into integer values though!


Resolution Resolution
Fixed Problem on 3/29/1999 in version 1.14 build 1
Image