Subject Re: NUMERIC(18,2) problem
Author csswa
--- 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

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?

Andrew Ferguson
-- Thesis, Antithesis, Andrew.