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]