Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

ptoye wrote

Glad to hear it. But IMHO Base is just nowhere compared  to Access (which
itself isn't much to shout about). And OO Basic compared to VBA similarly.
As an ex-programmer I'm always keen to automate any process, but the OO
Basic learning curve turns many people off (as far as I can see from
bulletin board comments - even this one) before they even start.

Agreed that MS have problems in forwards compatibility. But that's an
impossible dream. Can OO version 1 open OO version 3 documents?

Unfortunately I'm too short of time to contribute to OO/LO development - I
suspect there's another 2-year learning curve.

The whole office suite is about the ODF document standard. The database
connectivity is just a tiny extra. It lets you import arbitrary tabular data
into ODF documents for serial letters, labels and for calculation models.
Additionally you may attach very simple and very generic form controls (like
HTML forms) to ODF documents in order to write some data from your keyboard
or clipboard back into some editable database via ODBC or JDBC. 
That's all. No more, no less.

The "database application" called "Base" exists only as a
Nevertheless, this part of the office suite is extremely productive and
helpful as is.
In our small business we have almost no spreadsheet nor Writer document
which does not rely on some type of data source one way or the other. 
Writer's mail merge feature is far from perfect but if you have at least one
fairly computer literate person able to write very simple SQL queries, all
you need is the information: "Write your serial letter into template X and
connect the document with data source Y and query Z". The editor does not
need to care if data source Y is a database, a spreadsheet, a csv file or
something else. With a few clicks the new letter is connected to the right
In addition I implemented a small inventory database which is not offered as
a component of our proprietary business software. Everybody is happy with it
even though it is not as pretty and streamlined as it could be. With a few
lines of very simple macro code my database outperforms any "Excel
solution", let alone paper records. The first version was almost as good
with zero lines of macro code. 

If you want to earn money with perfectly streamlined database solutions
based on the Base component you surely would have to overstretch the whole
thing. Even if you'd learn everything about that API it would not help much
because the thing behind the API is not ready for business and propably
never will be because that would take hundreds of thousands of code lines
far beyond the scope of the ODF document standard.

View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.