To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64650 Issue #:|64650 Summary:|confusing error message when edit a query with |function in ORDER BY Component:|Database access Version:|OOo 2.0.2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|regina
------- Additional comments from [EMAIL PROTECTED] Sat Apr 22 15:23:39 -0700 2006 ------- Use the attached example database, which contains a table with ID, first name, last name and birthday. Goto "Create Query in SQL View..." and enter the command SELECT * FROM "Geburtstage" WHERE "Geburt" IS NOT NULL ORDER BY DAYOFYEAR( "Geburt" ) ASC Click on "Run Query" there in the toolbar to see that the query works. Save it and close dialog. Now in the query pane use context menu "Edit" to alter the query. You get the error message: SQL-Status: HY0000 Fehler-Code: 1000 Fehler in der SQL Syntax But the Syntax is OK and the query works fine. When you use "Edit", OOo tries to start in Design view. If a query cannot be edited in Design mode, OOo should not show such a error message. It should show a message like "This query cannot be edited in design view, SQL view will be used." --------------------------------------------------------------------- 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]