What are the challenges you face when working across database platforms? Take the survey
Options

'SQL Prompt formatting off' doesn't seem to work

Hi support,

My code is still formatted when using 'SQL Prompt formatting off'
pe9478i0l9b7.png

SSMS 13.0.16106.4
SQL Prompt 7.5.1.1000

Best regards,
Goos van Beek.
Tagged:

Comments

  • Options
    Russell DRussell D Posts: 1,324 Diamond 5
    edited May 15, 2017 8:04AM
    Did you format the SQL first, and then choose to disable formatting on the highlighted code? If so this doesn't work, you need to select the code you don't want formatting and disable formatting first, then format the rest of the sql.

    In the documentation it does say 'This code now won't be formatted when you run Format SQL.', but I'll see if we can make this any clearer.
    Have you visited our Help Centre?
  • Options
    goosvanbeekgoosvanbeek Posts: 4 Bronze 1
    Hi Russel,

    Thanks for your reply.
    Tried it both the ways you suggested, see the gif's below. Both with the same result. I expected the indention won't be formatted.

    Regards,
    Goos.
    e44yvpq76x9o.gif

    31td4tsad0fx.gif



  • Options
    Russell DRussell D Posts: 1,324 Diamond 5
    Thanks for just clarifying that - I'll raise it with the team.
    Have you visited our Help Centre?
  • Options
    goosvanbeekgoosvanbeek Posts: 4 Bronze 1
    After upgrading to SQL Prompt 8, 'formatting off' works as expected.
Sign In or Register to comment.