[nfbcs] Counting parentheses

[Doug Lee]

Of course this only works while authoring code, not reading someone else's, but...

My solution is to avoid counting them altogether: When I type an open paren, I also type the closing one, then
backspace once. I use the same trick for loop and if/else terminations and such: Write the full pair, then
fill in the new hole.

On Mon, Oct 26, 2015 at 12:18:35PM -0500, NFBCS mailing list wrote:
Listen to the sql query a character at a time adding 1 to the count each time
you cursor over a left paren and subtracting one each time you cursor over a
right paren.  It's like how they count cards in Vegas.


The only problem with this method is that you might get to the end of the
query and discover that you are missing a parenthesis but it might not be
clear where. What I would do in this case is do it again, this time listening
for the point where I know I should subtract 1 instead of add. Or just take a
shot and put a right paren at the end which is almost always the solution
anyway.




On 10/26/2015 12:01 PM, Tracy Carcione via nfbcs 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/jheim%40math.wisc.edu
>

-- 
John Heim, jheim at math.wisc.edu, 608-263-4189, skype:john.g.heim,
sip:jheim at sip.linphone.org

_______________________________________________
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/dgl%40dlee.org

-- 
Doug Lee                 dgl at dlee.org                http://www.dlee.org
SSB BART Group           doug.lee at ssbbartgroup.com   http://www.ssbbartgroup.com
"The U. S. Constitution doesn't guarantee happiness, only the pursuit
of it. You have to catch up with it yourself." --Benjamin Franklin