To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114188 Issue #|114188 Summary|Base query that references another query fails if subq |uery has order by statement Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab
------- Additional comments from [email protected] Sun Aug 29 21:58:10 +0000 2010 ------- Base's query designer allows you to reference another saved query, which is then substituted in as a sub-query in the statement sent to the database. However, if the sub-query contains an "order by" statement, this causes an SQL error (at least with the embedded HSQL database, other RDBMS may tolerate this syntax). I've also had problems if the subquery is something I've created in SQL mode and I've included a semi-colon at the end (again, this causes syntax errors when it is nested as a sub-query). The OpenOffice query parser needs to strip "Order by" clauses and terminal semi-colons when nesting queries. --------------------------------------------------------------------- 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]
