From: Dan Lewis <email@example.com>
Sent: Thursday, 20 September 2012, 16:10
Subject: Re: [libreoffice-users] Re: MS raised prices so people will now start renting their
office products instead
On 09/20/2012 09:10 AM, Pertti Rönnberg wrote:
I feel your point even if hidden. I understand your reaction but what you say is not an
explanation nor a solution - it does not change the fact that the Base's documentation is to
some extend misleading, uncomplete and not congruent with the programmed features. If you are
The Dan that has worked with the docs you have done a good job so far, but it must be finished!
And obviously you cannot do everything alone.
Yes, I am "The Dan", and progress has been very slow so far without any help. Besides I am no
programer nor have I taken any courses in database theory. It has come from searching the Internet
for information. I do have an advantage over some people: I have a mathematical background. Why do
I do this? It is a challenge to me, and this is the main point. People are much more likely to get
things done if they accept a challenge.
I personally can not help even if I wanted to: I am no programmer and I do not not know the
inner build-up of nor the relationships between Base's features and finesses.
I only am (was!) an user and can only contribute by proposing - and that I have done without
results - as far as I know.
I try again:
if you cannot get Base working as a standalone "database" (like MSAccess) then take the Base
module away from the LibO suite
or replace the old embedded HDBSQL v1.8 with a modern xxxSQL
HSQLDB 1.8 is not the real problem: it is the OOo chose to embed the database files within the
database document file. As a fork, LO has continued it. In fact, I requested that some changes be
made a long the line you mention. The reply by a developer was: it is not going to happen. There
is the incompatibility problem that could hamper any LO installment containing large number of
databases. (How does one change things over?) Meanwhile all of these databases are subject to data
loss because they will not make a change over.
The database files in an embedded database can be extracted to their own folder, add a prefix to
each one of them, tell Base what hsqldb.jar file to use, and use the Base Wizard to connect to
these files using JDBC. Now the database files serve as the backend, and Base can serve as the
front end. This works for either HSQLDB 1.8 that came with LO, or later versions that you download
and install on your computer from the HSQLDB website. Some of my databases require using 1.8 and
others require using 2.2.8. One of my LO versions uses 1.8 and another uses 2.2.8. (The two
versions of hsqldb are incompatible though.
I have also installed MySQL on my computer and use the MySQL Connector extension 1.0.1. I use Base
as a frontend for MySQL.
or make Base clearly an front-end (by totally removing the embedded part) and advice users to
an specific "real" background database (MySQL, SQLite, etc) and give them an easy-to-use and
really working software&docs for the connecting
reprogram LibO/Base so that a form can be built based on a query (not only on a table) and
then write/complete docs about how to build forms and subforms manually (no wizard)
borrow the Report Builder from OO and make it (really!) working in LibO -- together with
working docs about how-to
inform the user how to make a cover page (Mainform) for the database from where to open forms,
That as a beginning.
If or when Base works without problems and without bothering that list, I am lazy enough to
start using the rest of the LibO-suite.
On 20.9.2012 14:37, Dan Lewis wrote:
The reality of documentation is that very few people are willing to help produce it. This is
true of Base more so than the other components of LO. All of it is done by volunteers. If
people want better documentation, they need to do something about it. That means personally
testing various features and document what they find. It also means people stepping forward to
work with others to make the documentation better by collaborating.
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy