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: [email protected] 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
