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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.