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

Different format results cmd vs. Visual Studio

Hi,
I format a bunch of files in a folder with
SqlPrompt.Format.CommandLine.exe --i-agree-to-the-eula -p <folder> -s "Default" -n -is -ac
If I do a format in VS with every sql prompt setting = default I get a slightly different result in the comments:


gerry123
0

Comments

2 comments

Sort by
  • JoshH
    Hello Gerry, 

    I noticed this wasn't addressed yet. Can I ask if you are still having the issue?
    JoshH
    0
  • gerry123
    Hi Josh,

    Yes:
    Formated in MSMS:

    Formated with SqlPrompt.Format.CommandLine.exe:


    sqlprompt: 10.14.21.9884
    SqlPrompt.Format.CommandLine.exe: 10.12.6.30951

    demo sql:
    DECLARE @a1 INT = 0;
    DECLARE @a2 INT = 0;
    DECLARE @a3 INT = 0;
    IF (@a1 = 0) -- if comment1
    BEGIN
        SET @a1 = 10; -- comment2
                      -- comment3
                      -- comment4
        SET @a2 = @a1; --comment 5
    END;

    Now I see there are two versions Version of SqlPrompt.Format.CommandLine.exe, one in
    "c:\Program Files (x86)\Red Gate\SQL Prompt 10\"
    and one in "c:\Program Files (x86)\Red Gate\SQL Prompt 10\FormatCommandLine". I always used the second one (I think I exctracted it once from a zip). If I use the version directly in "c:\Program Files (x86)\Red Gate\SQL Prompt 10\" the problem is gone. 
    Sorry, my fault...

    Greeetings
    Gerhard

    PS: Maybe this is not true for the latest versions?


    gerry123
    0

Add comment

Please sign in to leave a comment.