[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 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 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 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 --- 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 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 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