Possible 3.6 bug
wtjones
Posts: 21
Type the following:
exec someproc 'abc'
Place your cursor in front of the first single quote and then try to type another single quote.
SQL Prompter will delete the new quote.
exec someproc 'abc'
Place your cursor in front of the first single quote and then try to type another single quote.
SQL Prompter will delete the new quote.
Comments
I'm not sure if this is what you're after, but you can actually modify this behaviour in the Options dialog. Go to SQL Prompt > Options, then Auto Insert > Closing Characters.
You can either disable auto-insertion of the single-quotation mark entirely (I wouldn't recommend this though) by unchecking "Single quotation mark" under "Define closing characters". You could also try unchecking the "Overtype duplicate closing characters" option.
Hope that helps.
Thanks,
Bart
Principal Consultant
bartread.com Ltd