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