[libreoffice-users] Re: Libre Office Base

Am 16.07.2015 um 10:51 schrieb Andreas Säger:
> Am 16.07.2015 um 09:15 schrieb Ian Whitfield:
> > Hi Andreas
> >
> > On 15/07/2015 17:32, Andreas Säger wrote:
> > > SELECT * FROM "Table" ORDER BY "what","you","want"
> > Thanks - I was hoping there was a way to do this from the GUI!!
> > >
>
> The GUI is almost useless compared to the options that are provided by
> the most basic SQL statements.
> Of course you may use the idiotic "query designer" to build a similar
> (though more complicated) query, but why?

In this particular case the query designer is stupid because you need to
include all the fields in the right column order. You can not select *
(all fields) and then apply some sort order on fields that are not visible.

And you can not define something like

SELECT "want", "what", "you"
FROM "Table"
ORDER BY "what","you","want"

where the field order differs from the sort order which does not matter
since the column order means nothing. In your forms and reports you are
free to use the fields in any column order.

There are many more reasons why the query designer is completely
inefficient and inadequate in the context of a relational database.
Writing down simple SQL statements is so much easier than using this GUI
rubbish. Quite often the designer turns a valid SQL statement into an
invalid one. Very often it fails to do mildly advanced stuff.
There are similar issues with the table designer, the index designer and
the form designer. The form designer is the worst member of the crew.


-- 
To unsubscribe e-mail to: users+unsubscribe@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