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

On 17.4.2012 12:34, ptoye wrote:
> Andreas Säger wrote
> > Why can't you run SQL update queries? This is trivial to do in SQL. The
> > SQL is trivial to execute by macro.
> > If you desparately want a graphical query designer for
> > update/insert/delete queries, then you should write one and store your
> > queries somewhere in the .odb container.
> Of course I can. If I can find out how to do it.
>
> But this isn't the point, is it? The real point is that database front-ends
> and macro languages are meant to make life easy, not difficult. You seem to
> dislike "sugar" - worried about your diameter? The computer was made for
> man, not man for the computer. Why not program in assembler - gives you much
> more control and isn't really that hard (I speak from years of assembler
> experience and with my tongue firmly in my cheek)?
>
> -----
> Peter
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html
> Sent from the Users mailing list archive at Nabble.com.

Well said Peter!

I totally and completely agree with you and Ian Whitfield.


And thanks to Ian for the tips about Kexi – I am almost ready for 
anything but LibO-Base.

Since the beginning of this year I have been trying to create a similar 
member register about a boy scout organization’s senior leaders also 
collecting memorable info from gone days – before these leaders are 
gone. The most I got from the efforts is waste of time and frustration.

A week ago Dan Lewis kindly sent to me drafts on documentation about 
creating a Base-db. It is very well written, clear, logic, easy to 
follow – but it is a draft, written in 2010 for OpenO. As far as I could 
see, there are nothing similar for LibO-Base yet.

Regarding LibO-Base’s situation today, very much should be helped if 
that Dan’s documentation should be completed and finished and included 
in the LibO’s (Base) introduction.

(When following Dan’s documentation I also noticed that in LibO-Base you 
can create a form /_based on a query_/ only using the Form Wizard – 
Design View allows you to create a form /_only based on a table = one 
table!_/)

To the LibO-folks and developers I repeat:

Stop developing LibO-Base;go back to the latest stable version and start 
to complete it and repair all discrepancies in the program and between 
the program and it’s documentation!

There is so much good done in LibO-Base so why not get the rest OK? So 
it at least should meet the promises in advertising.! Without problems!

And:
What (in @!?*@!??) can be the clever idea with having in LibO-base a 
embedded HSQL v.1.8 that is not supported any more when the latest 
version is 2.2.x? What about e.g. SQLite?

As Peter said:thus making the life easier  -- and if not easier but not 
more difficult!

Regards

Pertti Rönnberg


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