How can we help you today? How can we help you today?

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

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.

Mikael_H
0

Comments

7 comments

Sort by
  • 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.
    Tianjiao_Li
    0
  • 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 :)
    Mikael_H
    0
  • Tianjiao_Li
    I've added it to the bug report. I'll let you know when there is further update!
    Tianjiao_Li
    0
  • 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!
    Tianjiao_Li
    0
  • Mikael_H
    The problem occurs when I have insert-semicolon active and try to format a selection of the code:
    Mikael_H
    0
  • Tianjiao_Li
    @Mikael_H

    I'm pleased to let you know the fix it out now (9.4.2.7031). Please upgrade!
    Tianjiao_Li
    0
  • Mikael_H
    Thanks! Works as expected.
    Mikael_H
    0

Add comment

Please sign in to leave a comment.