Format SQL does not use Default Style

npetro

I have upgraded to SQL Prompt 4 and have run into an issue with the Format SQL option. I am using the Default Style and the Sample Query tab shows the SELECT statement with each column on a new line and the JOIN tables are indented nicely. However, when I click on the Current Query tab the style is not applied to my query. The only thing that happens is the spaces are removed and no formatting is done.

Do I need to set some additional settings or something to get the format option to use the default style? If not, then I believe the Format SQL option is not working properly.

Without this feature working properly, I may have to leave RedGate tools and I really like RedGate tools...

Anu D

Thanks for your post and apologies for the inconvenience caused by this issue.

Could you kindly send us the query and screenshots of your Data statements settings on support@red-gate.com so that I can replicate the issue and find any resolution?

Kindly include this forum link in your email.

Many thanks for your co-operation with this issue.

npetro

Dear Nick

Thanks for your email.

The alter view is the statement that is causing the issue with SQL prompt.

If you comment that ALTER VIEW AS line and try to check the 'Current Query' window it should be fine.

I have logged this as a bug in Jira whose id is SP-2770 and it will be addressed in our next release.

Sorry for the inconvenience caused by this issue.

Whenever you contact us, it helps us if you can include your call reference - F0025778.

Thanks,

Anuradha Deshpande

npetro

Dear Nick

Thanks for your email.

The alter view is the statement that is causing the issue with SQL prompt.

If you comment that ALTER VIEW AS line and try to check the 'Current Query' window it should be fine.

I have logged this as a bug in internal tarcking system whose id is SP-2770 and it will be addressed in our next release.

Sorry for the inconvenience caused by this issue.

Whenever you contact us, it helps us if you can include your call reference - F0025778.

Thanks,

Anuradha Deshpande

Anu D

Thanks Nick for posting my reply.

wsoranno

Any idea of a time frame for the fix for this problem?

I am having the same issue with a DECLARE tmp CURSOR FOR SELECT ... statement.

Everything is left justified.

Anu D

Many thanks for your patience regarding this issue.

I am pleased to inform you that we have fixed the SQL Prompt issue (SP-2770) you were experiencing 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.