[libreoffice-users] Re: Base - using external database tables

Am 13.10.2011 08:14, John Talbut wrote:
> Hi
>
> OK, let me go back to square 1.
>
> First of all I am not talking about a situation in which LibreOffice
> base needs to access data tables in separate files that use different
> database structures, e.g. one table is in MySQL and another is in
> PostgreSQL. This may be something that others need and I seem to recall
> that M$ access could do this but I do not need to.
Yes, MS Access can bundle many types of database tables as read-only 
links. Base connects one database file to one database served by one 
database server. A "database server" may be a directory or a file in 
some cases.

> Next, terminology because "database" can mean a number of things. Please
> correct me if I am wrong here. The data are contained in tables. These
> can be simple tables such as CSV tables or more complex tables
> constructed according to the rules of a particular database application.
> These tables can be in separate files or they may be embedded along with
> other information.
The built-in HSQLDB 1.8 (not Base!) is able to fill a prepared text 
table with data coming from a  (point decimals and ISO dates).
[Tutorial] Using csv/text files as editable data source:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=23260

[Example] Loading CSV into preformatted spreadsheets:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727
[refer to files #1 and #2]


> Now, to my situation. First of all I am using Debian GNU/Linux testing
> distribution. I use LibreOffice and for my database needs I use base. I
> use the built in HSQLDB database application and have my data tables
> embedded in the .odb file.

There is a serious issue with the combination of Linux +Java 
+Base(OOo/LibO).
[Solved] Extremely Slow search for item in base table:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=44451&hilit=Java


I'm sure this helps,
Andreas

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