https://bugs.documentfoundation.org/show_bug.cgi?id=166494
Bug ID: 166494
Summary: Wrong usage of decimal data(?)
Product: LibreOffice
Version: 24.8.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: tom.kuip...@hetnet.nl
Using Windows11 (Dutch settings)
LO-version 24.8.6.2
Database: Firebird (defined as server)
Table in Firebird: JAREN
Key-field J_NR Integer
Relevant field: J_OPBR numeric (5,1)
Table in LO: JAREN
Relevant field: J_OBR number
Macro used:
Global iOPBR as single
Global sSQL as string
SUB ReadInfo
sSQL = "Select J_OBR from JAREN where J_NR = 2025"
oConnect=ThisDatabaseDocument.DataSource.getConnection("","")
oQuery=oConnect.CreateStatement()
oResult= oQuery.executeQuery(sSQLstring)
oResult.Next
iJaarOpbrVerw = oResult.getstring(1)
etc.
End sub
When running as SQL in LO the result is 10,5
When displaying de value of iOPBR in macro the value is 105
When using iJOPR to populate a form-field defined with 1 decimal the value
displayed is also 105 and not 10,5 as expected.
What do I wrong and how to correct?
--
You are receiving this mail because:
You are the assignee for the bug.
