Re: Editable Form based on relational SQL query in Oo2.0 beta HSQLDB
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Helge, > When I set the content of my form to SQL I can edit and create table > entries without problems as long as I just select one table. With a > relational selection (I need an 1 to 1 relation withthe primary keys in > both tables) it's not anymore possible to create and edit entries. I > wanted to ask whether there is a possibilty to have a editable SQL based > content in a form which gets the data from two tables with unique > defined datasets? The subform function doesn't work very reliable (of > course it's beta) and it also complicates macro querys on the form > content. I would like to be able to just reload the form by macro, just > changing the SQL statement for the form content Though the code suggests we should be able to update queries across two tables, as long as all primary keys and/or unique index columns and entry-required columns a re present - I just tried, and it seems it doesn't work. Hmm. What is it that does not work with sub forms? Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -