Reported By: Graham Wood Reported On: 3/27/1999 For: Version 1.13 Build 1
# 392Saving 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!
ResolutionFixed Problem on 3/29/1999 in version 1.14 build 1