[dba-issues] [Issue 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 --- Additional comments from tony...@openoffice.org Fri Jan 2 17:23:45 + 2009 --- Hi there, Any update on this, is it in the pipeline for a future release? Whilst views don't have primary keys, it should not prevent them from being updated, afterall, that is why you can create updatable views in, not just MySQL, but Oracle and Postgres at least. Of course, the requirements for the views could be reduced, if tables from multiple sources can be linked into the single OODb file. Cheers - 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
[dba-issues] [Issue 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 User clu changed the following: What|Old value |New value Assigned to|clu |requirements Issue type|DEFECT|ENHANCEMENT --- Additional comments from [EMAIL PROTECTED] Tue Nov 18 14:24:50 + 2008 --- this is not supported = change in feature enhancement and send further to the requirements team p.s. views cannot be updated, because they have no primary key - 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 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 User clu changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |clu --- Additional comments from [EMAIL PROTECTED] Tue Sep 23 14:43:35 + 2008 --- change owner - 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 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 --- Additional comments from [EMAIL PROTECTED] Tue Jun 10 15:02:29 + 2008 --- Hi There MySQL version 5.0.24a-standard And connector mysql-connector-java-3.1.12-bin.jar Thanks Tony - 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 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 --- Additional comments from [EMAIL PROTECTED] Mon Jun 9 03:57:21 + 2008 --- Would you pass on which version of MySQL you are using and which type/version of a connector? - 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 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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 90393] Updateable MySQL views can not be updated via OOBase
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90393 Issue #|90393 Summary|Updateable MySQL views cannot be updated via OOBase Component|Database access Version|OOo 3.0 Beta Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|tony_52 --- Additional comments from [EMAIL PROTECTED] Thu Jun 5 11:28:00 + 2008 --- Hi All Seeing as though the multiple datasource ability is still not a working feature, I decide to try using updateable views in the My SQL database. So, taking the example of 2 MySQL databases. I have a table in Database 2, that I would normlly have as an additional data source in OOBase(if it was possible), as I currently do when using MS Access. An alternative idea I thought, was to create an updateable View on the table in DB2, in DB1. From withing MySQL I can update, amend this view, as if it was a local table on DB1. In OOBase, this view, in DB1, appears in the list of tables in DB1, however, in OOBase this view is read only, and not updateable. Oh well Cheers - 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]