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