Error when formatting in SQLCMD mode

JonBruneJonBrune Posts: 14 Bronze 1
in SQL Prompt
SQL Prompt is changing this:
:SETVAR MyVar      "Foo":SETVAR MyVar      "Foo"-- SQL Prompt formatting off
INSERT INTO #MyTable
(
    Col1
)
VALUES
 ('1')
-- SQL Prompt formatting on
</code>:SETVAR MyVar      "Foo"

-- SQL Prompt formatting off
INSERT INTO #MyTable
(
    Col1
)
VALUES
 ('1')
-- SQL Prompt formatting on
</pre><div>into:<br><pre class="CodeBlock"><code>
I'd like to submit a bug for this but it looks like the options are ask a question or start a discussion.  Maybe bugs are to be submitted elsewhere?


Tagged:
· Share on Twitter

Best Answers

  • Alex BAlex B Posts: 1,157 Diamond 4
    Answer ✓
    Hi @JonBrune,

    I see this happening as well - it seems specifically related to "-- SQL Prompt formatting off" comment following the :Setvar.  I have raised this with the team as SP-7591 and will update you when I have further information from the team.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • Alex BAlex B Posts: 1,157 Diamond 4
    Answer ✓
    Hi @JonBrune,

    The team has released SQL Prompt v9.5.4 which fixes this issue.  Please update to the latest version (download here) and confirm that it has corrected the issue for yourself as well!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter

Answers

Sign In or Register to comment.