[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User oj changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from o...@openoffice.org Tue Oct 5 07:22:39 + 2010 --- Closing - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from m...@openoffice.org Wed Mar 31 11:35:13 + 2010 --- verified in CWS dba33e find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33e - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from o...@openoffice.org Wed Mar 17 11:38:20 + 2010 --- Fixed in cws dba33e b: the query isn't valid when using access. Access can't handle column aliases well. c: contains ' as quote and not ` - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User msc changed the following: What|Old value |New value Assigned to|msc |oj Status|REOPENED |NEW --- Additional comments from m...@openoffice.org Mon Feb 22 11:47:36 + 2010 --- reassign back to oj - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User msc changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|FIXED | --- Additional comments from m...@openoffice.org Mon Feb 22 11:47:04 + 2010 --- reopen, because it's not fully fixed. a) 1. use the northwind example file. 2. use table "Categories" 3. as field insert "len( `CategoryName` )" 4. insert "length" as alias 5. switch to sql view 6. switch back to the design view 7. execute the query ==>> sql error. b) If I insert SELECT len( `CategoryName` ) AS `length` FROM `Categories` ORDER BY 'length' into the sql view and execute the query the result is not sorted. c) If I insert the sql from b) I can't switch to the design view - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Wed Feb 10 09:53:46 + 2010 --- Please verify. If you use the north wind db sample try this one SELECT len( `CategoryName` ) AS `length` FROM `Categories` AS `Categories` ORDER BY len( `CategoryName` ) ASC - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo 3.x |OOo 3.3 --- Additional comments from o...@openoffice.org Wed Dec 2 13:28:51 + 2009 --- Fixed in cws dba33e - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User mechtilde changed the following: What|Old value |New value OS/Version|All |Windows, all Platform|Unknown |PC Status whiteboard| |MS Access - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User oj changed the following: What|Old value |New value Target milestone|--- |OOo 3.x --- Additional comments from o...@openoffice.org Wed Jun 3 11:08:38 + 2009 --- set target. - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User atjensen changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj --- Additional comments from atjen...@openoffice.org Fri May 29 16:17:26 + 2009 --- Assign to developer - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from atjen...@openoffice.org Fri May 29 16:17:03 + 2009 --- Confirmed w/ 3.1 amd DEV300_m48 and btw 2.3.1 - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102366 --- Additional comments from wimbaet...@openoffice.org Fri May 29 14:19:29 + 2009 --- Created an attachment (id=62640) screenshots - 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
[dba-issues] [Issue 102366] No sorting possible with Alias in MS Access query
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 wimbaet...@openoffice.org Fri May 29 14:17:46 + 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org