| Subject | Using aritmetic operation with numeric fields in Firebird |
|---|---|
| Author | majstoru |
| Post date | 2006-09-10T15:37:50Z |
Hi,
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!
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!