Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Am 16.04.2012 14:49, Mark Stanton wrote:
- multiple table query/update support

Multi-table update support is an SQL limitation, isn't it?

At least it requires that a foreign key is linked to another table's unique (primary) key, otherwise it is uncertain which one of the related rows you are going to update.

This has improved in OOo 3.3. with embedded HSQLDB:
SELECT "A".*, "B".* FROM "A" JOIN "B" ON "A"."ID"="B"."AID"
selects an editable row set from 2 related tables (A.PrimaryKey=B.ForeignKey). For anything else there are subforms and list boxes. These two elements let you edit related tables in any case.

Comparing this supplementary tool set with a full featured database suite is not fair. Many people can not accept anything less sophisticated than MS Access. The difference amounts to a full decade with a multi-million dollar budget.

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.