statement terminator invokes sql prompt

jrandalljrandall Posts: 35
edited July 23, 2008 4:03PM in SQL Prompt Previous Versions
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.

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • 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 DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.