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

Error when formatting in SQLCMD mode

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?


JonBrune
0

Comments

3 comments

Sort by
  • Alex B
    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
    Alex B
    0
  • Alex B
    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
    Alex B
    0
  • JonBrune
    Thanks Alex.  That fixed it.
    JonBrune
    0

Add comment

Please sign in to leave a comment.