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 [email protected] On 6 October 2012 03:23, John Clegg <[email protected]> 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 <[email protected]> > 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: > [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 > > > > > > -- > 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 > > -- 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
