How can we help you today? How can we help you today?

statement terminator invokes sql prompt

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

Comments

3 comments

Sort by
  • 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
    Eddie D
    0
  • 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"
    jrandall
    0
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.