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

Uppercased Comments

When Case Settings is set to "Force UPPERCASE" keywords are uppercased when I type comments. Is there some way to get this function to leave comments alone?
jlspublic
0

Comments

4 comments

Sort by
  • Tilman
    Hi,

    It shouldn't be doing that. Can you give me an example where this is happening? Also what editor are you using?

    Regards,

    Tilman
    Tilman
    0
  • jlspublic
    I'm using the Microsoft SQL Server Management Studio and, after further experimentation, I've determined that the problem only occurs if I create a block comment inside a CREATE PROCEDURE method like this:

    CREATE PROCEDURE Bob
    AS
    BEGIN
    /*
    JOIN us IN celebration OF this discovery.
    */
    END

    As you can see from the way that SQL Prompt capitalized the SQL keywords in the comment I typed, it doesn't recognize that that line is a comment. For now, I am working around this by pre-pending the "--" comment tag to the comment lines which gets SQL Prompt to leave them alone.
    jlspublic
    0
  • Tilman
    Hi again,

    Yup, that's a bug. Thanks for reporting it and sorry for the inconvenience.

    Regards,

    Tilman
    Tilman
    0
  • jlspublic
    Thanks for looking into this.

    I also want to thank you for your prompt and frank acknowledgment that this is a bug. Too often I find that component/tool vendors go out of their way to sweep these types of problems under the rug. It's refreshing to have someone take responsibility and communicate with users openly, like professionals.

    -JLS
    jlspublic
    0

Add comment

Please sign in to leave a comment.