To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113184 Issue #|113184 Summary|Table won't open if sort field is renamed Component|Database access Version|OOO320m12 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|tintazul
------- Additional comments from tinta...@openoffice.org Fri Jul 16 10:17:56 +0000 2010 ------- Create a table, let's call it myTable. Create any number of fields, but include a field named oldName. Open the table, and in the view order the table by oldName. Close the view. Then edit the table again, and change the name of oldName to anything else (newName). Now try opening the table again. You'll be given an error message. My OOO is in Portuguese, but here's the info when you click "More" on the error message: Estado SQL: S0022 Código de erro: -28 Column not found: myTable.oldName in statement [SELECT * FROM "myTable" ORDER BY "myTable"."oldName"] You will not be able to open the table unless you revert your changes: 1) edit the table, change the field name back to oldName 2) open the table, remove the sorting 3) edit the table, change the field name to the desired newName 4) open the table, add sorting again on the same field, now named newName Solution to bug: when changing a field name, change also any queries referencing it, in this case particularly in the open table view. Sorry if this was doubly reported... I couldn't make out how to operate the bug search! --------------------------------------------------------------------- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
