Re: Support for Updatable Views in OOo2 (MySQL 5.0.7-beta through Connector/ODBC 3.51)

Darren Wurf wrote:
> 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!
Update:

Armed with the knowledge that OOo won't insert data into a table that 
doesn't have a primary key, I tried to put a primary key on one of my 
views. It looks like MySQL doesn't support this (I don't know whether 
this is unimplemented or by design).

Anyway, I discovered I can create a query, and build a form based on 
this for viewing subsets of data (and performing inserts/updates too).

Cheers!
-- 
Darren