I am using Libreoffice base 18.104.22.168 (x64) on Windows 10 with a newly splitted HSQLDB database. I have setup a database with tables, queries and forms in order to write invoices and keep control of a stock situation.
I followed the excellent tutorial to split HSQLDB databse and copied all my tables, queries etc… using the JDBC driver to connect. Now I noticed that some SQL I had used within the invoice form does not work anymore and I cannot see why that is.
It basically is a formula to extend the final price after calculating a discount, it goes as following:
( “ITEMS”.“PRICE” - ABS( COALESCE ( “SOLD”.“DISC_CURRENCY”, 0 ) ) ) * “SOLD”.“QTY” * ( 1 - ABS( COALESCE ( “SOLD”.“DISC_PERCENT”, 0 ) ) )
Does anybody see any reason why this wouldn’t work anymore? Could this be due to the ABS not being accepted?
Thanking you in advance for any idea
EDIT: same goes for some macro (from form to print).