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: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
