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

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

Riho-Rene Ellermaa
senior programmer
Hansabank