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

Hi,

jowyta schrieb:
> 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

?? What kind of file? A database is not a file, but normally has a lot 
of files.

, even if they
> used the same database structure

?? 'database structure'. Which database you tried to use?

, then base could not link to more than
> one of them. This seems to be a facility that various people need.

Not really. You are usually not running two databases. I guess, that 
there is an error in how you have organized your data.

> 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?
Extracting to a file depends on the database engine.

Before someone can help you, you need to describe what database kind you 
use at all. A database with own database management like MySQL or 
DBase-tables or ...?

Kind regards
Regina



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