[libreoffice-users] Re: Problems importing an OO database into LO

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: users+help@global.libreoffice.org
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