https://bugs.freedesktop.org/show_bug.cgi?id=62689
Priority: medium
Bug ID: 62689
Assignee: [email protected]
Summary: Getting wrong 'double's from sql-DB with
libreoffice-basic
Severity: critical
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: NEW
Version: 3.5.7.1 rc
Component: BASIC
Product: LibreOffice
Since version 3.5.7 of libreoffice I get wrong double values in
libreoffice-calc from the mySql database with libroffice-basic. It worked fine
until 3.5.4.
The query using mysql - commandline:
[code]
mysql> select eurprice from items where itemcode ="wbv";
+----------+
| eurprice |
+----------+
| 8.6000 |
+----------+
1 row in set (0.00 sec)
[/code]
The same from libreoffice-calc with libreoffice-basic, _same database_ of
course:
[code]
Dim price as double
Dim selectString as string
Dim Statement As Object
Dim ResultSet As Object
selectString = "select eurprice from items where itemcode = '"wbv'"
Statement = gConnection.createStatement()
ResultSet = Statement.executeQuery(selectString)
.... ' some error handling here
price = ResultSet.getDouble(1)
[/code]
For 'price' I get just '8' instead of '8.6'
The code above had proven to work for some years now, but since my update to
3.5.7 (Ubuntu:1.3.5.7 to be precise) my reults are wrong. With 3.5.4 everything
was still fine.
After downgrade from 3.5.7 to to 3.5.4 everything is fine again.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
