At one client, this week's production check-in of an application developed in MS Office (mostly
Access) 2007/2010 code is now up to:
110,315 LOCs, 380 Modules, 249 Stored Procedures, and counting...
This is a client/server application backing up to a SQL back-end database.
I am interested in the capabilities of LibreOffice Basic along the same lines.
The documentation for LibreOffice Basic seems very space compared to MS VBA.
Does LibreOffice Basic even support Object Orientated Class development? I have double class wrapped each logical type of data record. One level is the DB table class, which manages INSERT / UPDATE /
SELECT type operations with a consistent interface. The next class layer is a Validation class which handles DB class to Form Control mapping (to/from) and also performs data type validation on the
fields, marks bad data fields red/error, and so on. Also I make extensive use of in-memory collection classes: Thing / Things classes, where the Things class contains one/many Thing class object
What sorts of database drivers are available cross-platform? (Linux and Windows) I use a mix of ADO and DAO drivers for VBA code. ADO Command / Parameter objects when possible, ADO Recordset objects
second. Both of these ADO options leave the data in VBA variables, so works very well for record INSERT / UPDATE forms. For Multiple Items forms displaying a read-only list of records I use nested
DAO.QueryDef objects to issue queries in Pass-Through mode to execute a Stored Procedure, then an outer DAO.QueryDef wrapper to copy selected records into an FE DB temp table for local display. At
first I would like to use MySQL as the BE DB for use with LibreOffice.
Lueck Data Systems
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
- [libreoffice-users] Serious application development with LibreOffice and LibreOffice Basic · Michael Lueck
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