Subject Re: [ib-support] How to handle money fields
Author Carlos H. Cantu
Are you using IB 6.0 with dialect 3 ?


WarmBoot Informatica -
Interbase-BR -

RRE> I 'm having troubles with money fields. When I calculate medium prices in
RRE> StoredProc, the result is sometimes like 10.3453453. I want to store it like
RRE> 10.35.
RRE> When I created field like NUMERIC(15,2), I thought that it would round the
RRE> number OK. But it seems that it only shows it rounded, calculation are still
RRE> done with it's full value. I searched then for the round function, but
RRE> didn't find it.

RRE> There must be some easy solution to it. I can't imagine that I'm the only
RRE> one using Interbase for accounting software and that Interbase developers
RRE> didn't take money handling problems into account.

RRE> Riho-Rene Ellermaa
RRE> senior programmer
RRE> Hansabank

RRE> To unsubscribe from this group, send an email to: