SQL Prompt - Bug?

CMeese

We have some older procs that use PWDCOMPARE. We've found that SQL Prompt does not work (e.g., no intellisense, no auto-formatting, etc.) if we type statements after the PWDCOMPARE. In the same proc SQL Prompt works fine when typing before PWDCOMPARE.

way0utwest

What version of SQL Prompt? Seems to work in v8

CMeese

Version 8.2.2.2657.

Maybe it's the use of PWDCOMPARE in a statement such as:

When I change my SQL to be like your example SQL Prompt works fine:

way0utwest

That's strange. Yep, seems like a bug. Reporting to the dev team

CMeese

great, thanks!

krzysztofkroczak

Hi @CMeese and @way0utwest,

Thank you for reporting this. I've managed to reproduce the problem locally and I've created a bug (reference: SP-6655) to track it.

Best regards,
Krzysztof