I have an application that I took over programming. Its written in Delphi 7, uses SQLDirect (BDE replacement), and Firebird 1.5.6
There are float fields all over the database storing currency values. I believe this to be causing all kinds of rounding errors. I have been researching , but I'd like some confirmation. I think i read that numeric(18,4) was the best way to store them with BCD enabled in BDE settings is that accurate or what else would be better? I am pretty sure i need to change all those floats to something, enable BCD and then the programming in delphi side can just remain the same? I get mixed information and can't tell what versions of what they are using. Any help would be appreciated. Thank you!! [Non-text portions of this message have been removed]
