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 +0000 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]