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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
