To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42522 Issue #:|42522 Summary:|Query Design View - rearranges/loses order by |statements Component:|Database access Version:|OOo 1.1.4 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|ronald_k
------- Additional comments from [EMAIL PROTECTED] Fri Feb 11 04:06:44 -0800 2005 ------- 1) ORDER BY statements get rearranged when a query is designed in text editor mode, and then the design view is activated and deactivated. Query written in text editor mode: SELECT `firstname`, `surname` FROM `test`.`person` `person` ORDER BY `surname` ASC, `firstname` ASC After activating and deactivating the design view: SELECT `firstname`, `surname` FROM `test`.`person` `person` ORDER BY `firstname` ASC, `surname` ASC This is because in design view, the firstname column is before the surname column. Problem: If you design a query in the text editor mode and save it, all is ok. But when editing this query later, the editor starts in design view this rearranges the ORDER BY statemens. 2) ORDER BY statements get lost, when the not refering a column name. Query written in text editor mode: SELECT CONCAT( `surname`, ', ', `firstname` ) AS `name`, `age` FROM `test`.`person` `person` ORDER BY `name` ASC, `age` ASC After activating and deactivating the design view: SELECT CONCAT( `surname`, ', ', `firstname` ) AS `name`, `age` FROM `test`.`person` `person` ORDER BY `age` 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]