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


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

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.



Michael Lueck
Lueck Data Systems

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.