Uh, what just happened?

Dave PendletonDave Pendleton Posts: 104 Bronze 3
edited February 4, 2010 6:48AM in SQL Prompt Previous Versions
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.

Comments

  • 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.
  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • 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!
    Regards

    William
  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • The same thing happens with DECLARE CURSOR
    Doug Heeren
  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.