queries - linked tables --> editing failure

[dutch002001]

Gentlemen,

I am a very frustrated user. There are several questions, but only one will be presented per posting.

OS: MS Vista Ultimate, SP 1
CPU: AMD 64 bit
OO version: 2.4.0
Database: native to OO.base

Background:
2 select queries, each of which permit editing as stand alone queries, or when incorporated in a form separately.

One query incorporating the 2 mentioned above linked by a foreign key/key relationship. The resulting query is read only, both as a stand alone query and embedded in a form, the form being set to permit both edit of existing records and the addition of new records. I have not found any way to make the results both read/write/add.

Question:
What causes this, and is there a solution/workaround.

Thank you,

Dutch

.

[kabing]

It is a limitation/feature of Base and/or the embedded hsqldb engine that the data in queries combining fields from more than table are not editable.

Sorry to be the bearer of bad news.

kabing

[dutch002001]

Dear Kabing,

Your reply is what I expected. I just hoped to be wrong.

This does deteriorate the value of the database as a replacement to Microsoft's Access. For several reasons I'd really hoped to escape Microsoft.


Thank you very much,

Dutch


.

[kabing]

I don't know if this helps you or not, but in terms of forms it is possible to use subforms to edit data from multiple tables. To be editable, the main form and subforms have to be based on tables, not queries.

kabing

[dutch002001]

Dear Kabing,

Your suggestion is one I failed to perceive.

I use subforms all of the time for 1 to many relations and the single valid use of a many to many relationship I've Identified. There is no obvious reason why a subform would not work for 1 to 1 relationships.

It looks like my next step is to learn how to add a subform to an existing primary form.

Thanks for the suggestion.


Dutch

[kabing]

Dear Dutch,

You're welcome.

In terms of adding a subform, this tutorial may be of help. It is written for Neooffice 2.2.3, which is based on the OpenOffice.org 2.2.1 codebase.

Since NeoOffice is based on OpenOffice.org, the instructions should work fine for OpenOffice.org, if you keep the following things in mind:

• 1) references to the command key in a Neo tutorial are the equivalent to the control key in OOo. (i.e. Command-C becomes Control-C) Note that I'm not sure if this is true with OOo for X11.
  2) control-clicking is the same as right clicking
  3) icons sometimes look different, as NeoOffice 2.2.2 has a custom icon set.

kabing