Hi :) I think Base can either use an SQL-based back-end or LO Calc spreadsheets. Just not both at the same time.
Errr, the rest of it was a bit over my head! Hopefully someone else will be around soon Regards from tom :) >________________________________ > From: Michael Lueck <[email protected]> >To: [email protected] >Sent: Tuesday, 18 June 2013, 22:05 >Subject: [libreoffice-users] Re: Serious application development with >LibreOffice and LibreOffice Basic > > >Greetings All, > >I successfully warped up the application development project I described. >Final end-of-project stats were as follows: > >Total >123,576 LOC's, 413 Modules (Classes/Modules/Forms/Reports), 264 Stored >Procedures, and fin! > >It has a Front-End (FE) which is the bulk of that code, an automated >replication application transferring data from the production JDE ERP system >for use by the application I built, and finally I >developed for them an application server architecture to asynchronously >process requests without tying up the FE application. > >The legacy application this new one replaced had the following stats: >1,366 LOC's in 12 module(s) > >So, getting finally back and replying... > >Mark LaPierre wrote: >> Your post was requesting some guidance for "Serious application development >> with LibreOffice and LibreOffice Basic". My reply was intended to >> communicate the fact that LO Base is very limited when it >> comes to serious uses. > >I guess I can now see what you were communicating. > >> LO Base is not capable of connecting to an SQL based back end, and linking >> to a LO Calc spreadsheet at the same time. <snip> > >Is LO Calc spreadsheets really the preferable file format for LO Base data? > >> That one restriction was enough to disqualify LO Base from consideration for >> what I consider to be a very simple application. > >That is unfortunate. > >Wolfgang Keller wrote: >>>> At first I would like to use MySQL as the BE DB for use with >>>> LibreOffice. >>> >>> That's a B-A-D idea if you want to get your data back in a consistent >>> state with a certain reliability. Use PostgreSQL instead. > >MySQL is trusted by this client organization to handle their production >website... LAMP software stack. Why would it suddenly not be reliable for back >office Client/Server use? > >I guess for the moment I will leave the DB requirements in Access, and later >port them to Free Pascal / Lazarus when I have the time to get up-to-speed >with that cross platform serious development tool. > >Thank you all for your helpful responses. Actually last week I came across a >link referring to StarOffice... I had forgotten that origin in the LibreOffice >history timeline! > >Sincerely, > >-- >Michael Lueck >Lueck Data Systems >http://www.lueckdatasystems.com/ > > >-- >To unsubscribe 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 > > > -- To unsubscribe 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
