[libreoffice-users] Re: Problems importing an OO database into LO

Le 17/04/12 18:14, Andreas Säger a écrit :

Hi all,

> The easiest improvements in my honest opinion:
> - Wipe out the .odb container all together and get back to the
> configuration of database access in OOo 1. Back to external databases
> with configuration data in configuration files, forms and reports in
> stand-alone office documents. More speed more safety, security,
> accessibility and transparency. People who do not understand how to
> connect separated software tools do not understand the .odb container
> neither (as we can read in all the mail merge topics).
> - Remove all the half done wizards. Do not improve them. Remove! No
> database developer nor interface designer needs all this stinky rubbish.
> There are graphical tools to compose forms and reports within office
> documents. There is SQL for all the rest, including all the things we
> can not do in the current graphical interface. There are plenty of SQL
> editors to produce valid SQL for various databases. SQL text can be
> pasted into any database configuration.
> - Add native database queries, so the current "direct SQL mode" returns
> editable row sets and the (useless or even harmful) graphical query
> designer can be removed as well.
> - Having removed all the wizards (they are Java components) without
> losing any functionality at all, extensions could substitute .odb
> packages. When you open the extension, the database gets installed
> _permanently_ (rather than _temporarily_ like the .odb) into the
> configuration tree together with the forms and reports documents. The
> database will be registered and all the tables, queries, forms and
> reports are accessible form the data source window, hyperlinks and
> desktop links just like it used to be in OOo 1.

Ah, nostalgia those were halcyon days ;-)

+1 (not that that means anything in our "user land".

Unfortunately, as I was told quite a while ago either on the dev-list or
IRC dev channel, or bugzilla,  "no-one wants to go back to 10 year old
technology", i.e. the LO devs are not interested in undoing what Sun it
its infinite wisdom thought would be a good idea when it "re-invented
OOo-Base", so we are stuck with what we have until someone steps up and
decides to either unravel it all or improve it - a mammoth task by
anyone's standards.


Alex



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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