[dba-issues] [Issue 113184] Table won't open if sort field is renamed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113184 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from o...@openoffice.org Fri Jan 14 08:24:50 + 2011 --- Please verify. Thanks. - 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 113184] Table won't open if sort field is renamed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113184 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo 3.x |OOo 3.4 --- Additional comments from o...@openoffice.org Thu Jan 6 12:41:56 + 2011 --- Fixed in cws dba34c. The order by clause will now be removed when the column is not part of the table anymore. - 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 113184] Table won't open if sort field is renamed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113184 --- Additional comments from f...@openoffice.org Fri Nov 26 15:10:14 + 2010 --- note: There's another workaround than renaming the field back: When you opened the table, and got the error message, simply click the "Remove Filter/Sort" button in the toolbar. This will remove the complete filter/order clauses, in particular the broken one. - 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 113184] Table won't open if sort field is renamed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113184 --- Additional comments from r4z...@openoffice.org Sat Jul 17 12:33:45 + 2010 --- Created an attachment (id=70673) bugdoc - 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 113184] Table won't open if sort field is renamed
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113184 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW OS/Version|Mac OS X |All Platform|Macintosh |All Target milestone|--- |OOo 3.x --- Additional comments from r4z...@openoffice.org Sat Jul 17 12:32:36 + 2010 --- I can confirm it on win7 with DEV300_m84 and OOo 3.2.1, OOo 3.1.1. I add example file, with error message. The field name in /database/script changed to newName, but possibly the UI parser keeps oldName when you try to open. Same happens when you close file and OOo, and restarts it back, open file, open table. Assign developer, set target to OOo 3.x. - 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 113184] Table won't open if sort field is renamed
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 + 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