Re: [libreoffice-users] Re: Update SQL does nothing using "Run SQL directly" button

On 10/07/2012 07:28 AM, Marion & Noel Lodge wrote:
> Hi Jay,
>
> On 6 October 2012 14:55, Jay Lozier <jslozier@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
> lodgemn@gmail.com


-- 
Jay Lozier
jslozier@gmail.com


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