In our DBISAM app, we mistakenly used floats all over the place where the field was really holding currency values.

1.What would be the recommended DataType to hold "good old dollars and cents" in FB?

2. It appears that a numeric(12,2) would handle any single amount that we would come across...but does it have any issues when running a query who's sum would be more like 15,2 ?

3. Since we did use floats in the beginning, our client app is careful about rounding everything before posting. Is there any downside to leaving these fields as floats?

Thanks again and again,
Kumar Manuel



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