LO/Firebird - subtraction issue and other operations

Creating tables and queries

LO/Firebird - subtraction issue and other operations

Postby pinco pallo » Wed Jul 10, 2019 4:31 pm

Hi, I have an issue with an embedded Firebird database with LO 6.2.
In my table one is decimal =12,0 and two is decimal=10,0.
Why the subtraction one-two = 20?
Why the additions one+two = 220?
Why the division one/two = 120?
Why the product one*two = 12000?
Thanks so much.
Last edited by pinco pallo on Wed Jul 10, 2019 5:01 pm, edited 1 time in total.
AOO 4.1.3 on Mac OSX
pinco pallo
 
Posts: 85
Joined: Tue Jul 16, 2013 2:24 pm

Re: LO/Firebird - subtraction issue

Postby RoryOF » Wed Jul 10, 2019 4:36 pm

Your comma is not being treated as a decimal point.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 30226
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LO/Firebird - subtraction issue

Postby pinco pallo » Wed Jul 10, 2019 4:43 pm

Thanks for your quick reply.
But even changing the decimal separator from comma to point (choosing English in the Format dialog box) things don't change.
Attachments
Schermata 2019-07-10 alle 16.43.57.png
AOO 4.1.3 on Mac OSX
pinco pallo
 
Posts: 85
Joined: Tue Jul 16, 2013 2:24 pm

Re: LO/Firebird - subtraction issue and other operations

Postby Villeroy » Wed Jul 10, 2019 9:57 pm

Test_Firebird.odb
(3.73 KiB) Downloaded 31 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27606
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LO/Firebird - subtraction issue and other operations

Postby pinco pallo » Thu Jul 11, 2019 7:01 am

Thank you. But not in MyTest:
Schermata 2019-07-11 alle 06.58.16.png

Where am I wrong?
Attachments
MyTest.odb
(3.51 KiB) Downloaded 31 times
AOO 4.1.3 on Mac OSX
pinco pallo
 
Posts: 85
Joined: Tue Jul 16, 2013 2:24 pm

Re: LO/Firebird - subtraction issue and other operations

Postby Villeroy » Thu Jul 11, 2019 1:41 pm

Because your query is not the same as mine.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27606
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LO/Firebird - subtraction issue and other operations

Postby chrisb » Thu Jul 11, 2019 1:46 pm

i have not downloaded any of the attachments related to this topic but suspect that the answer lies here>> https://ask.libreoffice.org/en/question ... breoffice/
the use of CAST is required:-
Code: Select all   Expand viewCollapse view
cast("Column1" - "Column2" as decimal(8,2)) "Column1-Column2"
in my humble opinion there are currently so many bugs in libreoffice base & embedded firebird in particular that it can not be trusted.
open office 4.1.7 & LibreOffice 6.3.2 using HSQL 1.8.0.10 (Embedded) and HSQL 2.5.0 (Split) on Windows 10
chrisb
 
Posts: 206
Joined: Mon Jun 07, 2010 4:16 pm

Re: LO/Firebird - subtraction issue and other operations

Postby Villeroy » Thu Jul 11, 2019 1:56 pm

+1

Use LibreOffice instead of OpenOffice but not the new Firebird engine that integrates so poorly. I do not blame anybody. It could be Firebird not obeying certain standards, it could be the Base developers of old OpenOffice.org, it could be the LibreOffice crew. There is nothing wrong with HSQL. Even the old embedded version works better than Firebird, and if you switch from embedded HSQL to external HSQL2 you get a really nice backend playing almost perfectly together with Base.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27606
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LO/Firebird - subtraction issue and other operations

Postby pinco pallo » Thu Jul 11, 2019 2:28 pm

Villeroy wrote:but not the new Firebird engine that integrates so poorly

I thought I was doing something right with Firebird. If I select HSQL LO it says:
Schermata 2019-07-11 alle 14.20.43.png

chrisb wrote:the use of CAST is required

Better to give up immediately if I need to reformat the fields in all the queries.
AOO 4.1.3 on Mac OSX
pinco pallo
 
Posts: 85
Joined: Tue Jul 16, 2013 2:24 pm

Re: LO/Firebird - subtraction issue and other operations

Postby pinco pallo » Thu Jul 11, 2019 2:49 pm

The problem also exists with a new database connected.
Is it possible that the developers have done this stupid thing?
AOO 4.1.3 on Mac OSX
pinco pallo
 
Posts: 85
Joined: Tue Jul 16, 2013 2:24 pm

Re: LO/Firebird - subtraction issue and other operations

Postby Villeroy » Thu Jul 11, 2019 4:29 pm

Yes, they did this stupid thing.
menu:Tools>Options>Advanced turn off experimental features and you won't be prompted for conversion anymore.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27606
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 2 guests