Options
Another thing still broken in 5.0
Sphelabaum
Posts: 12
This is one of a few fixes I mentioned over a year ago now, so I assume it is one of the harder things to fix, but just in case it isn't and just somehow fell off the radar, I figured I'd mention it again:
It affects both ' and ). Basically, if you try to type another one of these characters with your cursor to the left of an existing one, it does not insert another one, it replaces your existing one. While I've more or less grown used to it at this point, it is still somewhat confusing at times and makes me pay more attention to it than I'd like to. It's a larger annoyance when you're dealing with things requiring 5+ ) or ''s in a row.
With that out of the way, I also wanted to thank you for adding one of my requests with the Script as Alter functionality. That definitely made my day.
It affects both ' and ). Basically, if you try to type another one of these characters with your cursor to the left of an existing one, it does not insert another one, it replaces your existing one. While I've more or less grown used to it at this point, it is still somewhat confusing at times and makes me pay more attention to it than I'd like to. It's a larger annoyance when you're dealing with things requiring 5+ ) or ''s in a row.
With that out of the way, I also wanted to thank you for adding one of my requests with the Script as Alter functionality. That definitely made my day.
Comments
Thanks for the post.
I think this was originally by design but it's a textbook case of software trying to be smart but not smart enough. We noticed users often typed the closing ' or ) regardless so we wanted to prevent inserting two, which makes sense when you write out statements in one pass but sometimes falls over when you then go back and want to make edits, as is often the case. I agree, this behaviour is annoying but unfortunately it was beyond the scope of this release, which focused on merging and retiring SQL Refactor.
Regards,
Luke Jefferson
Product Manager
Red Gate Software
E: luke.jefferson@red-gate.com
Unfortunately, it overachieves even there, and replaces them regardless of your options, as I have never found the auto inserts useful myself and turned them off.
I doubt that makes it any easier to fix, and you most likely were aware of that as well, but figured I'd note it just in case.