--- In ib-support@y..., Daniel Rail <daniel@a...> wrote:

> I have some fields defined as NUMERIC(18,2), but in the database

they have

> 3 decimals and the third decimal sometimes has a value and this

throws off

> some calculations. The field definition is used for currency

fields.

From what I understand about IB numerics, if you have a field defined
as numeric(18,2) but you are getting a greater scale (decimal places)
then the underlying field is actually DOUBLE PRECISION. This only
happens with Dialect 1 databases. Is yours 1 or 3?

Regards,
Andrew Ferguson
-- Thesis, Antithesis, Andrew.