statement terminator invokes sql prompt

jrandall

Whenever I type a semi-colon as a statement terminator, SQL Prompt displays a candidate list. I don't understand the purpose of that behavior, nor do I see anywhere in the options to turn that behaviour off.

Eddie D

Sorry that you have encountered this problem.

I have been unable to replicate your issue.

What version of SQL Prompt are you using?

Have you made any changes from the default Trigger words (SQL Prompt ->Options ->Pop-up Behavior Tab ->Triggering)?

Many Thanks
Eddie

jrandall

As far as I know, I have the most recent version of SQL Prompt, and to the best of my recollection, I have not altered the Triggering list. Try typing this into an new SSMS query window:

SET NOCOUNT ON;

As soon as I type the semicolon, a list of keywords pops up, beginning with "ALTER"

Eddie D

Thank you your reply.

I agree with you this is a bug within SQL Prompt.

I have submitted a bug report to highlight the problem to our development team.

I have tested for this bug in SQL Prompt 3.8 and 3.9.

Hopefully the bug will be fixed in the next release of SQL Prompt.

Many Thanks
Eddie