To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103428
------- Additional comments from f...@openoffice.org Wed Aug 12 12:21:48 +0000 2009 ------- Yes, that's a formatting issue. "truncate" returns decimal values, and for whatever reasons, Base applies the "Standard" numeric format to columns t_1, t_2 and t_3, but "0,00" to t_0, which explains the seen values. With the JDBC driver, "Standard" format is assigned to t_0, "0,0" to t_1", "0,00" to "t_1", and "0,000" to t_3. This makes me think that the result set meta data returned by the driver is not correct. That is, I suppose we determine the number format from the decimal accuracy returned by the driver, and in the case of C/OOo, this seems to be wrong. Can probably be confirmed or falsified with a small Basic macro, perhaps I'll find some time to check this. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org