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

On 10/05/2012 10:13 PM, Marion & Noel Lodge wrote:
> I discovered one useful feature of the SQL Button.  I like to format my SQL
> queries by putting SELECT, FROM, WHERE etc. each on a separate line, plus I
> use tabs to line up the various table names, again on their own line.  I
> find  this makes complex queries much more readable.
This actually standard practice for writing queries. Another common
practice is to capitalize SQL key words, which you appear to also do.
> If the SQL Button is on, then this formatting is saved when the query is
> saved.  If the button is off, then next time the query is opened in edit
> mode, the code is all in one long line!  I used to find this quite annoying.
>
> Noel
> --
> Noel Lodge
> lodgemn@gmail.com
>
>
> On 6 October 2012 03:23, John Clegg <john.clegg@nailsea.net> wrote:
>
> > That button, according to the help file, toggles whether the SQL is passed
> > directly to the database engine or handled by Base first. I'm not quite
> > sure what that means in effect!
> >
> > On 5 October 2012 18:12, David S. Crampton <david_crampton@ie2b.com>
> > wrote:
> >
> > > John and the others who responded,
> > >
> > > It took me a while to realize that the useful SQL menu is available only
> > on
> > > the main / opening window of the db. The SQL button in the Query Design
> > > view
> > > still appears to do nothing.
> > >
> > > I'm finally getting some traction. I acknowledge and appreciate the
> > > "stylistic" suggestions. This year and month data is very unlikely to
> > > change
> > > once the transaction record is accurately entered.
> > >
> > > Thank you, all,
> > > David
> > >
> > >
> > >
> > > -----
> > > --
> > > David S. Crampton
> > > --
> > > View this message in context:
> > http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902p4011374.html
> > > Sent from the Users mailing list archive at Nabble.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
> > --
> > 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


-- 
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