Options
4.0.3 Adds ' when it shouldn't while indenting
MikeyC
Posts: 249 Bronze 3
Given this code:
And having the code between <select start> and <select end> selected when you hit TAB to indent it.
This is what you get:
while this is what I expect:
SELECT <select start>'Test' AS Field1, 'Test2' AS Field2, ''<select end> AS Field3 INTO #Temp
And having the code between <select start> and <select end> selected when you hit TAB to indent it.
This is what you get:
SELECT 'Test' AS Field1, 'Test2' AS Field2, ''' AS Field3 INTO #Temp
while this is what I expect:
SELECT 'Test' AS Field1, 'Test2' AS Field2, '' AS Field3 INTO #Temp
Comments
As per steps provided by you I tried to replicate the issue but it works fine for me.
Can you kindly email me the screenshot of the settings:
SQL Prompt 4 --> Options --> Inserted Code --> Special Characters ?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
this happened to me as well earlier after installing the update, although I couldn't get it to do it again after re-selecting the start and end points and tabbing again.
Just wanted to confirm you're not crazy.
I just sent the email to support@red-gate.com.
(Just for reference the options I have checked are:
* Add parentheses
* Single quotation mark
* Comment mark
* Square bracket)
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569