Uh, what just happened?

Dave Pendleton

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

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 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.

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!

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.

douglasheeren

The same thing happens with DECLARE CURSOR

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.