Subject Using aritmetic operation with numeric fields in Firebird
Author majstoru

I'm using Firebird 2 and I have a table with a few numeric field
which is set to NUMERIC 15, 5.
When I need to make sam SQL statement like SELECT NumField1 *
NumField2 (where is numeric fields are NUMERIC 15, 5) FROM Table
I get error "Integer overflow The result of an integer operation
caused the most significant bit of a result to query".

I must have a Numeric number with a 5 decimal places, because of
better precision!
Is there another type of numeris which can I use for this operation
or some anoter solution, OR I'm wrong :-(!

Thans for help to all Firebird members!