Created attachment 129903 [details]
Open the query. Have a look at the fields, which should show absolute numbers.
Open the attached document.
Open the query.
There are numeric and decimal fields of the Firebird 3.0-database.
To every field is asked for ABS("Fieldname").
The function works right, if the field-length is 10 or 11. Could be for all values greater than 9.
The function ignores the decimal places for field-length less than 10. There are reported hundredfold values instead.
Arch Linux 64-bit, KDE Plasma 5
Build ID: fc0d4e6bc43d5f982452df07930f5ecf5927ad22
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on December 31st 2016
Have tested this again:
SELECT ABS(-23.45) FROM "Table"
SELECT ABS(CAST(-23.45 AS NUMERIC(10,2))) FROM "Table"
You have to change the fieldtype and switch the length to min. 10 and the function will give the right value.
Build ID: d9cfbabc7fe13752daf02e2a8cfa38c72a30fb29
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-01-22_23:06:33
Locale: de-DE (de_DE.UTF-8); Calc: group
Works now with fix of