To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 Issue #|102366 Summary|No sorting possible with Alias in MS Access query Component|Database access Version|OOo 3.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|wimbaetens
------- Additional comments from [email protected] Fri May 29 14:17:46 +0000 2009 ------- Reproduce: * Connect to an existing MS Access DB. * Create a query with an expression, e.g. len( 'fieldname' ) * As such, you can use this expression as a sort condition * When assigning an alias to this expression (e.g. Length instead of Expr1001), sorting produces an error message. I believe the answer lies with the generated SQL. It seems that the alias should not be copied to the 'ORDER BY' part of the SQL. (I will attach some screenshots) (Another issue is that, after saving, this query can no longer be edited in design mode. It can only be opened in SQL view and even then, saving is no longer possible due to 'parsing errors' But maybe this is a side-effect of the bug) --------------------------------------------------------------------- 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]
