Hi, I have heard numerous people saying that they had bad experiences with using the native Currency type or Numeric(15,4) type to store currency values in a database. They reported rounding errors, or not the correct rounding methods were used, display issues etc...
I have experienced similar issues with storing percentages with decimal values as Numeric(3,3) in a Firebird database. It displayed really weird values in the GUI in the scientific format eg: 2.516e+1 Their solution was to rather store currency values as integers - currency amount converted to cents. I have done similar for my percentage values and it works perfectly now. The Business objects handly the Rands, Dollar, Pounds (decimals) etc..., but when stored in the database, it's an integer value. Anybody else been doing this? If so, over the long term, how have you found it. Workable - I guess I can't see why it wouldn't? Regards, - Graeme - _______________________________________________ fpGUI - a cross-platform Free Pascal GUI toolkit http://opensoft.homeip.net/fpgui/ _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
