https://bugs.documentfoundation.org/show_bug.cgi?id=166494
--- Comment #1 from Tom <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_OPBR number
Macro used:
Global iOPBR as single
Global sSQL as string
SUB ReadInfo
sSQL = "Select J_OPBR from JAREN where J_NR = 2025"
oConnect=ThisDatabaseDocument.DataSource.getConnection("","")
oQuery=oConnect.CreateStatement()
oResult= oQuery.executeQuery(sSQLstring)
oResult.Next
iOPBR = 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 iOPBR 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.
