Problems with Auto Closing Characters:
When I type
SELECT '
SQL Prompt changes the code to
SELECT ''
which is correct because I have apostrophe as an auto closing character.
However if I type
SELECT 'blah'
and then accidently erase the last apostrophe and then try to go back to it and type it again, I get:
SELECT 'blah''
because SQL Prompt tried to auto close the apostrophe even though it was the closing apostrophe.
The same goes for trying to type code that put an apostrophe (or whatever) in your text. For example.
SELECT 'blah' - results in blah
select '''blah''' - results in 'blah'
but you cannot do this with SQL prompt because for every time you type one apostrophe a second is added. For this second issue I would suggest adding the feature to momentarly turn off the auto close feature is the user presses the Esc key while he/she types the apostrope (or whatever)
When I type
SELECT '
SQL Prompt changes the code to
SELECT ''
which is correct because I have apostrophe as an auto closing character.
However if I type
SELECT 'blah'
and then accidently erase the last apostrophe and then try to go back to it and type it again, I get:
SELECT 'blah''
because SQL Prompt tried to auto close the apostrophe even though it was the closing apostrophe.
The same goes for trying to type code that put an apostrophe (or whatever) in your text. For example.
SELECT 'blah' - results in blah
select '''blah''' - results in 'blah'
but you cannot do this with SQL prompt because for every time you type one apostrophe a second is added. For this second issue I would suggest adding the feature to momentarly turn off the auto close feature is the user presses the Esc key while he/she types the apostrope (or whatever)