To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49043
------- Additional comments from [EMAIL PROTECTED] Thu Dec 8 03:02:11 -0800 2005 ------- Datatype and formatting of date and non-date number columns in queries also appears to be a related problem to the original description of this issue, depending on how a query is submitted. For example, while in design mode, date columns are returned as number formatted values but numeric,2 columns correctly return data as 9999.99. However, if a query is submitted directly through SQL, date columns are shown correctly as date format, but numeric,2 columns are displayed with 16 decimal places. By changing the format of date columns when in design mode (right-click, Column Format in query with data displayed in the grid) dates are then correctly displayed, but on saving and re-executing the query the date columns revert to number. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
