Re: [libreoffice-users] Base - using external databases
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
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+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
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+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
Re: [libreoffice-users] Base - using external databases
Hi, jowyta schrieb: Hi 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? Kind regards Regina -- 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