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

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.

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

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