Change in formatting behavior (Ctrl+K, Ctrl+Y)?

Mikael_H

I often use the formatting feature by selecting a piece of code and apply format to that section only. My source window typically contains other sections of unfinished code.
This has been working great up until recently. Now the formatting is applied to the _whole_ windows and fails to format if there is any error in the code. Environment where I have the "old" behavior: SSMS 13.0.16106.4 and SQL Prompt 9.1.8. Environment with "new" behavior: SSMS 14.0.17277.0 and SQL Prompt 9.2.6.
I hope there is an option to change behavior for this.

Tianjiao_Li

Hi @Mikael_H

Thanks for reporting this issue! 

I've reproduced it and logged as SP-7205 in our internal bug tracking system. I'll keep you posted.

Our apologies for the inconvenience caused.

Mikael_H

If I disable the format Action "Insert semicolons", I can format a _selection_ of the code. But I like the "Insert semicolon" action too, so I guess I have to write correct code all the time

Tianjiao_Li

I've added it to the bug report. I'll let you know when there is further update!

Tianjiao_Li

Hi @Mikael_H

The issue appears to be related to associated refactoring with formatting than formatting itself.

If you can provide us with your sample script, we'll try to make sure it's fixed for your script!

Mikael_H

The problem occurs when I have insert-semicolon active and try to format a selection of the code:

Tianjiao_Li

@Mikael_H

I'm pleased to let you know the fix it out now (9.4.2.7031). Please upgrade!

Mikael_H

Thanks! Works as expected.