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

Uh, what just happened?

I installed SQL Prompt 4 this morning.

I've been happily coding in both Visual Studio and SMSS all day, formatting away as I go, then bang.

Nothing.

Every format operation left justfies all the SQL.

No formatting whatsoever.
Dave Pendleton
0

Comments

6 comments

Sort by
  • Dave Pendleton
    I'm writing lots of views today.

    If I format a procedure, or some other SQL, everything works as expected. When I format one of my views, everything is left justified with no formatting.

    When I remove the CREATE VIEW ... AS, and format only the SELECT everything works as expected.

    The view SQL compiles just fine.
    Dave Pendleton
    0
  • Anu D
    Thanks for your post Dave and apologies for the issue you encountered with SQL Prompt 4.

    I was able to reproduce your issue hence I logged it as a bug in our internal tracking system. Id for this bug is SP-2773.
    This issue will be addressed in our next release.

    Once again sorry for the inconvenience caused by this issue.
    Anu D
    0
  • williamd
    Hi there,

    Is there a planned release date for this fix? We are on Version 4.0.2.53 and the problem is still there.

    The workaround works fine, but we would like to have it working as in v3.

    Many thanks!
    williamd
    0
  • Anu D
    Thanks for the post.

    I will update this post as soon as we nail down a date for release.

    Thanks for your patience and co-operation.
    Anu D
    0
  • douglasheeren
    The same thing happens with DECLARE CURSOR
    douglasheeren
    0
  • Anu D
    Hello All,

    Many thanks for your patience regarding this issue.

    I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing (SP-2773) in our latest patch.

    Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248

    Please let us know if this fixes your issue.
    Anu D
    0

Add comment

Please sign in to leave a comment.