Re: Re: Base form read only
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Gert, > But when I create a query for a select statement like "Select * from > StockMaster, CategoryMaster", i.e. a query on *two* tables, the generated > form does not allow any editing of data at all. > > What am I doing wrong? Nothing, I fear :-\ Just recently somebody else stumbled upon this: You cannot update queries joining two tables, unless they contain (IIRC - would have to look into the code or ask my colleague :) ) a JOIN. That means that "SELECT A.a, B.b from A, B where A.b = B.ID" is not updatable. Try changing the connection between A and B: In the query design, double-click the connection line, and change it's Type to something else - does this help? Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -