On 17/04/2012 23:58, Andreas Säger wrote:
We are using OO-LO as a front end to connect to MySQL, we no longer use
the LO-forms etc , but we usesDialogs and their controls (also Drids and
the DataSourceBrowser)who are feeded with the MySQL-data.
Reporting is done by feeding WriterDocs with the data, or
Calc-spreadsheets for data oriented reports. Exporting to a spreadsheet
is very slow when feeding the sheet cell by cell. But using the
"doimport" on a cell range is lightning fast.
For Connecting, we use the NativeConnector. We trie to avoid using a
OO-LO dbase doc(fro safty reasons) and connect directly using the
DriverManager. This method has a important drawback, The
DataSourceBrowser is not working without connecting with dbaseDoc.
when low volume selections (100 lines)using the GridControls is very use
full but becomes to slow for big selections, here is the DataSource
browser a possible workaround. GridControls however have the advantage
that we can "color" every line, whats make it far more user friendly.
This system is used by 100 users , who can do all their tasks with only
Am 17.04.2012 19:23, Tom Davies wrote:
It looks like most of this can be done without touching Base itself?
Is LO able to use databases in this way already? Is it something
that could be passed to the devs list an/or the BoD discussion list?
Something like this could be phrased to capture the imagination,
Saying it's the old way might put them off.
I use to use Base like this. I connect a Base document to HSQL 2.8
databases with forms and reports on the desktop (spreadsheet reports
are sufficient for us). The Base container is nothing but a
configuration file storing the connection URL, SQL query strings and
the default log-in (and I left some rarely used admin forms in it).
My users do not know anything about the database document.
The content of the database document could be some XML and query
strings in the configuration tree (just like it used to be in OOo 1).
For unsubscribe instructions e-mail to: email@example.com
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
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