Formatting fails

torsten.strauss

Hi Redgate Team

Highlighting the first command only to format just this statement will fail cause Redgate already is trying to parse the second statement as well.

This behavior is different to the former version.

Please fix this cause otherwise it is not possible to reformat only a specific code block !!

SELECT 1/1

SELECT

Thanks!

Torsten

Tianjiao_Li

Hi @torsten.strauss

Thanks again for reporting this issue!

It's logged as SP-7115 in our internal bug tracking system now. I'll keep you posted.

Our apologies for the inconvenience caused.

torsten.strauss

Hi Tianjiao,

can you please consider this with high priority cause it is impossible to work with Redgate on longer Scripts where there is only one parsing issue (undocummeted syntax,etc.) in the entire script.

Thanks!

Torsten

MVP Data Platform

Tianjiao_Li

Hi @torsten.strauss

Thanks for your patience. Just to let you know this bug is in the current support stream. I'll speak to the development team for further update.

Tianjiao_Li

Hi @torsten.strauss

Sorry to let you know this bug is moved to backlog now due to the size of high priority tasks. Our apologies for the inconvenience caused. Please keep an eye on the release note!

TomW

Hi @torsten.strauss

We made significant changes to the formatting and refactoring system a while ago (version 9.4.1 of SQL Prompt) which solved this issue. This post seems to have slipped through our net, so please accept our apologies for not notifying you sooner.

Kind Regards,
Tom