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
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: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: 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