John On Wed, 2011-10-12 at 14:52 +0100, jowyta wrote:
> 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 > If I understand your problem you have table in one database and you need to access from another database. For example you have in MySQL/MariaDB or PostgreSQL two databases called VendorAccounts and Inventory. Your query/view/function/etc. must access one table in each to get the relevant data. (MariaDB is a FOSS fork of MySQL and can easily replace MySQL) My first question is what is your backend? Next how are you connecting to the backend? For example MySQL/MariaDB have several possibilities depending on the network and database server location. I have MySQL/MariaDB installed on my desktop and can access it using direct connection, odbc, and jbdc - I normally use direct connection. Also, have you checked the documentation for your backend for the syntax for querying tables in different databases? MySQL/MariaDB use the SQL union to do this. What is your OS and LO version? -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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