[nfbcs] Counting parentheses

[Aaron Cannon]

It probably doesn't help much, but I typically just keep count in my head. If it is too complicated to do that, I will often rearrange the SQL statement into multiple lines with the contents of each set of parentheses indented another level. I can then very easily see, by the change in indentation where I may need to close a parentheses block. This works, of course, because my editor informs me about indentation level changes.

Failing that, if the Abacus works for you, then why not get A few more, so that you're  more likely to have one when you need one?

Aaron

--
This message was sent from a mobile device


> On Oct 26, 2015, at 12:01, Tracy Carcione via nfbcs <nfbcs at nfbnet.org> wrote:
> 
> I am having trouble keeping track of parentheses in complicated SQL
> statements.  Perhaps when I know SQL better, it will be less confusing.
> Sometimes I have an abacus handy to keep track of counts, but not always. 
> What methods do people use to make sure there is a ) for each (?
> Thanks.
> Tracy
> 
> 
> 
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/cannona%40fireantproductions.com