Are you using IB 6.0 with dialect 3 ?

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

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:
RRE> ib-support-unsubscribe@egroups.com