On 10/07/2012 07:28 AM, Marion & Noel Lodge wrote:
> Hi Jay,
>
> On 6 October 2012 14:55, Jay Lozier <[email protected]> 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
> [email protected]
>
--
Jay Lozier
[email protected]
--
For unsubscribe instructions 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
