(Version: 9.0.2.1621)
I love the autoreplace function.
I prefer using it with 'special characters' (like * and ^) for two reasons:
1. to make sure an alias is only autoreplaced if it's followed by this character
for example: "for*" will be replaced by a for-loop construction, but "for" will not.
2. to make a distinction between different types of replacement text.
for example:
typing tablealias abc* will be replaced by "select abc.* from my_abc_table abc;"
typing tablealias abc^ will be replaced by "my_abc_table abc"
Now I find that only a few special characters work with autoreplace.
So far only * and ^ seem to work.
If for example I have an entry
cnt_ = select count(*) from
The string cnt_ does not get replaced. If I change the underscore into an asterisk or a carrot it does.
Am I doing something wrong?
Furthermore:
Following advise in another thread, I have also tried turning of autoreplace in the preferences, and assigning a shortcut-key to "Editor: Autoreplace".
For me, this would be a very acceptable way to handle reason 1. (In fact I would love to use it this way)
However,
In the program-window that was open when I went to preferences all works as expected: no automatic autoreplace, hitting the shortcut key initiates a replace.
But when I close that program window and open a new one, still no automatic autoreplace (as expected) but no reaction to the shortcut key either. All other customized key's work perfectly.
Does anyone know why?
Erik van Roon
I love the autoreplace function.
I prefer using it with 'special characters' (like * and ^) for two reasons:
1. to make sure an alias is only autoreplaced if it's followed by this character
for example: "for*" will be replaced by a for-loop construction, but "for" will not.
2. to make a distinction between different types of replacement text.
for example:
typing tablealias abc* will be replaced by "select abc.* from my_abc_table abc;"
typing tablealias abc^ will be replaced by "my_abc_table abc"
Now I find that only a few special characters work with autoreplace.
So far only * and ^ seem to work.
If for example I have an entry
cnt_ = select count(*) from
The string cnt_ does not get replaced. If I change the underscore into an asterisk or a carrot it does.
Am I doing something wrong?
Furthermore:
Following advise in another thread, I have also tried turning of autoreplace in the preferences, and assigning a shortcut-key to "Editor: Autoreplace".
For me, this would be a very acceptable way to handle reason 1. (In fact I would love to use it this way)
However,
In the program-window that was open when I went to preferences all works as expected: no automatic autoreplace, hitting the shortcut key initiates a replace.
But when I close that program window and open a new one, still no automatic autoreplace (as expected) but no reaction to the shortcut key either. All other customized key's work perfectly.
Does anyone know why?
Erik van Roon
