Subject | Re: NUMERIC(18,2) problem |
---|---|

Author | csswa |

Post date | 2002-04-30T15:50:08Z |

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

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.

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

> 3 decimals and the third decimal sometimes has a value and thisthrows off

> some calculations. The field definition is used for currencyfields.

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.