Re: [libreoffice-users] Base - using external databases

Regina Henschel wrote

jowyta schrieb:

> > A long unresolved problem with OpenOffice.org base was its
> > inability to link to more than one external database at a time.
> > See: http://openoffice.org/bugzilla/show_bug.cgi?id=42464

> > It is for this reason (needing to link to more than one table) that
> > I have had to use base's internal HQLDB database.

> I don't understand your reasoning. The issue is about connecting to
> two different databases with the same odb-document. For example
> connecting to MySQL and PostgreSQL at the same time. That has
> nothing to do with more than one table. You can have as much tables
> in a database as you need.

> What is your problem and in which way does the internal HSQLDB helps
> you?

My problem was that if I had tables in different files, even if they 
used the same database structure, then base could not link to more than 
one of them.  This seems to be a facility that various people need.

It might be a solution for me if I could have several tables in the same 
file provided that I could manipulate them from base rather than having 
to use a separate database programme.  If this is possible, are there 
some instructions somewhere as to how to extract the data to a separate 
file?

Kind regards

John

--
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