Support for Updatable Views in OOo2 (MySQL 5.0.7-beta through Connector/ODBC 3.51)
Darren Wurf <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi! I'm having problems with views in Base under OpenOffice.org 1.9.113. I can do the following through OOo: * Create tables * Perform inserts/updates on tables * Create views However I can't create new records in a view (even when the view is eg 'CREATE VIEW foo2 AS SELECT * FROM foo;' - ie a copy of the underlying table). Performing inserts from the command line client works fine (within the restrictions of mysql's updatable views implementation). I am using OOo to create a front end to a db for a small office, so I'd like to be able to work with updatable views to minimise the number of records that are sent across the network. So, my questions are: 1) Does OOo support updatable views: - at all? - through ODBC? - when using MySQL? 2) - If no, are there plans to support this for the 2.0 release? - If yes, or if there is another way to achieve the same results, how is this done? Thanks! -- Darren