I have rounding problems too - but not with Firebird (I starting with
Firebird).


Try use "Currency" variables and use ".asCurrency" instead "asFloat". Try it
first!



De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de chris meelhuysen
Enviada em: quarta-feira, 21 de dezembro de 2011 19:22
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Dealing with Currency in FB 1.5.6





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]





[Non-text portions of this message have been removed]