AutoReplace Enhancement Request

[mike]

I love autoreplace and use it all the time. Sometimes though, it would be nice to turn it off temporarily. I see I can disable it in the preferences, but I would like to have a key configuration to toggle it.

For example, I have "s" replaced by "SELECT" and I like that almost always. In comments, I end up with "it'SELECT" every time I type "it's" though. It would be nice to turn it off, type my comment and turn it back on with a hot-key.

Thanks for considering,

Mike

 

[Marco Kalter]

I have added this to the list of enhancement requests. I would have expected that the Undo function would have undone the replacement (like in MS Word), but this is not the case. My guess is that Undo would already help you out?

We'll enhance this.

 

[F. van Boven]

Shouldn't the autoreplace allways be disabled with typing comments? Or maybe make it a setting...

 

[Marco Kalter]

It should be disabled when typing comments or strings. We'll check it out.

 

[Roeland]

Could you add a keystroke to enable/disable the autoreplace in strings.
Please make it a toggle, so I can disable it when not appropriate.
This feature will come very handy when I'm writing and updating dynamic sql code.

Thanks,

Roeland

 

[vlevi]

I have 8.0.4.1514, but for me, the autoreplace does not works between string quotes. I think it is fine now.
In the options/key configuration, there is a line called editor:autoreplace. Assign a hotkey for this, and autoreplace will be invoked, even inside a string variable. This is not a toggle autoreplace on/off, only a single invoke of autoreplace.
It also works, if you have autoreplace disabled by default.

 

[William Robertson]

Perhaps single-character autoreplace strings aren't such a good idea

I use:

begin=H:\settings\PLSQL Developer\Templates\begin.tpl
echo=dbms_output.put_line(
execute=execute immediate
exists=H:\settings\PLSQL Developer\Templates\exists.tpl
liek=like
for=H:\settings\PLSQL Developer\Templates\for-loop.tpl
freom=from
if=H:\settings\PLSQL Developer\Templates\if.tpl
loop=H:\settings\PLSQL Developer\Templates\loop.tpl
newline=dbms_output.new_line();
rae=H:\settings\PLSQL Developer\Templates\Raise_application_error.tpl
s*=select * from
sc*=select count(*) from
seelct=select
selct=select
selcet=select
showp=show parameter
tehn=then

 

[mike]

I think you have a good point William.

Since my original request, almost all of my auto-replace strings are followed by an asterisk. For example, p* invokes my procedure template.

s, f, and w are the only single character ones now and I use them so often that I've decided it's OK for the occasional "it'SELECT" stuff.

By the way, I love autoreplace and use it all the time. I like that it can open templates. AllroundAutomations did a good job with that.