Greetings,
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.
TIA!
Sincerely,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
--
For unsubscribe instructions e-mail to: [email protected]
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
