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 +0000 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