Hi!

Recently I found out that the Float type not support big values, like
9,999,999.99. When I try to use this values in my system (that uses float
type) it rounds the values.

Now, I know that I must change all my field types that are float to
other one. But my problem is: which other???

I'm in doubt between DOUBLE PRECISION, NUMERIC and DECIMAL. Which is the
best one?

I have in my system values with 2, 3 or 6 decimals point. I need to use
one type that permits all this decimals and control it by the mask. What do
you suggest me???


PS.: I use IB 6.01


Thanks