What are the challenges you face when working across database platforms? Take the survey

Closing characters - single quote

pikespikes Posts: 2
edited October 13, 2016 10:42AM in SQL Prompt
I think there may be a bug in SQL Prompt that's causing an issue when I type single quotes. When I start to do an IN statement and type a single quote, it creates 2 single quotes and puts my cursor in between them. This is great and intended, however, if I type another single quote without typing anything else (when I want to indicate an empty string), it only inserts one single quote and puts my cursor after it so now i have 2 single quotes before my cursor, and one after instead of simply moving the cursor past the single quote it just created. Is there a way to fix this?


  • Options
    James RJames R Posts: 104 Silver 4

    Thanks for reporting this issue. We have been unable to reproduce this here, could you tell us these details :

    1) Your current SQL Prompt version number. This can be found under SQL Prompt - Help - About
    2) Your SSMS version.
    3) A before / after screenshot of the issue just to make sure we're looking at the same problem.

    Software Engineer
    Redgate Software
Sign In or Register to comment.