Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.