On 10/07/2012 07:28 AM, Marion & Noel Lodge wrote:
> Hi Jay,
>
> On 6 October 2012 14:55, Jay Lozier <jsloz...@gmail.com> wrote:
>> This actually standard practice for writing queries. Another common
>> practice is to capitalize SQL key words, which you appear to also do.
> I was aware that formatting a query was good practice - not so sure that it
> is standard practice. If it is, then the standard, in my experience, seems
> to have lots of variations! I've seen some queries that were pretty hard
> to read. Because the compiler doesn't care about formatting, it seems that
> many people come up with their own "standard" (or have it enforced by their
> employer).
I tend to follow the formatting practices I see in most texts.
SELECT columns
FROM tables
WHERE conditions
SELECT ....
This seems to be reasonably readable in many situations. What I have
seen to difficult to follow is a very complex WHERE clause.
>
> Be that as it may, the main point I was making in my post was that with the
> SQL Button off, any formatting is stripped out. The query is apparently
> handled by the Query Wizard which doesn't seem to know anything about a
> formatting standard. It would be good if this could be added to the wizard
> some time. I think code to do that would be quite tricky to write, which
> may explain why it hasn't been done to date.
>
> Thanks for your comment.
>
> Noel
> --
> Noel Lodge
> lodg...@gmail.com
>
--
Jay Lozier
jsloz...@gmail.com
--
For unsubscribe instructions e-mail to: users+h...@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
