[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Wed Jul 18 06:55:03 + 2007 --- *** Issue 73132 has been marked as a duplicate of this issue. *** - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 User fs changed the following: What|Old value |New value Assigned to|requirements |fs Target milestone|--- |OOo 2.x --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 10:01:12 + 2007 --- IMO, we should implement this for at least HSQLDB, which is our default DB engine. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 User fs changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 10:03:19 + 2007 --- accepting - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Mon Jun 11 17:48:27 + 2007 --- Great news! I was only thinking of being put right for HSQLDB. Most other databases should have their own native ways of editing views. However, in theory, it shouldn't matter as the process should always be the same. 1) Query the database schema to acquire the view definition - this should be a CREATE VIEW statement. 2) Load this into the Design view dialog. 3) Save changes back with a DROP VIEW and a CREATE VIEW for the new definition. But I'm sure there is a big gulf between theory and practice. I see, for instance, that HSQLDB holds the view definitions in a pure text Script file while query definitions are in the contents.xml file. So best of luck! People like me with minimal coding ability really appreciate what you are doing. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Mon Jun 4 06:30:26 + 2007 --- *** Issue 78050 has been marked as a duplicate of this issue. *** - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 User ajpursell changed the following: What|Old value |New value CC|''|'ajpursell' - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Mon Jun 4 22:39:40 + 2007 --- Now my issue 78050 has been closed and merged with this I have to back moorsider's assertion that this is a DEFECT, not an ENHANCEMENT. There can be no defence that it cannot be done, as it is being done for queries. A view is essentially the same animal as a query. It is defined by an a SQL statement that can be represented by a Design view in just the same way. MS Access does just that and allows you to change views in Design view or by editing its underlying SQL statement. This problem should have been fixed long ago. All issues raised on this topic have called it a DEFECT. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Mon Jan 9 02:49:45 -0800 2006 --- *** Issue 60249 has been marked as a duplicate of this issue. *** - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Mon Jan 9 04:28:54 -0800 2006 --- The facility to edit a view is still an enhancement, as its a feature which is currently not available, and not designed to be available. The fact that you can choose Edit when a view is selected could be considerd a bug, since there's no backend support for editing views. However, the immediate fix for this bug would be to disable the Edit in this case (or name it Show structure or whatever), but *not* to implement editable views. - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 --- Additional comments from [EMAIL PROTECTED] Fri Oct 14 00:50:11 -0700 2005 --- *** Issue 55964 has been marked as a duplicate of this issue. *** - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 49183] Can't edit view's design
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49183 User fs changed the following: What|Old value |New value Assigned to|msc |requirements Ever confirmed| |1 Status|UNCONFIRMED |NEW Issue type|DEFECT|ENHANCEMENT OS/Version|Windows NT|All Platform|PC|All --- Additional comments from [EMAIL PROTECTED] Fri May 13 00:13:30 -0700 2005 --- Well, the point of a view is: It's a query which can be used like a table. So, if you could use queries in queries, this would be views :) Nonetheless, it might be desirable to edit a view's design later on, unfortunately, this is barely supported by the databases ... - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]