Hello all,
I have an interesting error setting up a database with LO 7.0.2.2. I’m running on a Mac OS X 10.16, database is firebird embeded.
I need to setup a series of tables for a relational database that will calculate simple multiplications and divisions among tables. Since I need the data to be quite precise I have set up the fieldtype as Numeric with 6 decimals (18,6). This will be used for analysis where I do need to detect differences at a decimal level accuracy, hence not using a float type. I set up all of the tables and when I did the first query I got the following error:
firebird_sdbc error:
*Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.
caused by
‘isc_dsql_fetch’
The data going into the query was quite simple, along the lines of 82.990.00123.991.001100
I have read about the error and have tried:
-casting the query as numeric (10,4) no success
-Casting the query as Float, no success
At this stage I am just stuck it what I am sure is a simple solution that might have to do with the way I set up the datatype.
Any suggestions will be greatly appreciated