Re: Base form read only

Hello Gert,

I'm answering your mail in [email protected], which is the better
place for this kind of questions. This is a matter of scaling (more
people than me could answer), and a matter of sharing knowledge (more
people than you might benefit from the answer).

Please also reply to this mailing list. You can subscribe to it at
http://dba.openoffice.org/servlets/ProjectMailingListList, or read it
via the mail/news-gateway at news.gmane.org.


In general, a form, when you double-click it, always reads "readonly" in
its title. That's a known issue, the readonly here refers to the
"document" as such - you cannot insert new controls or something like
that -, not to the database data which is shown/edited with the form
document.
So, please first make sure it's not only the title which is confusing you :)

Then, is the problem only related to forms, or also to the underlying
table, if you open this table directly?
In general, OpenOffice.org can only update tables if they have a unique
index, or a primary key defined, see
http://dba.openoffice.org/FAQ/FAQ.html#dataupdate for more information.

Other than this - hmm, no idea without more information.

Ciao
Frank

Gert Blij wrote:
> Hi Frank,
> 
> Sorry to bother you, but I have tried everything else (That I know off, KB,
> user list, draft manual, etc.)).
> 
> I have been using 2.0 for quite a while, 122 at the moment, but Base only
> recently.
> 
> I have linked it successfully to MySQL and everything works fine, except for
> creating a table update form. Whatever I do, the form generated is always
> "read only" mode.
> 
> How do I create a form that I can use to change the contents of table
> fields?
> 
> TIA
> Gert
> 


-- 
Frank Schönheit, Software Engineer            [email protected]
Sun Microsystems Germany                          +49 / 040 23 646 500
StarOffice Database                      http://www.sun.com/staroffice
----------------------------------------------------------------------