Speed Typing

Speed typing configuration is accessible through menu Tools->Configure Speed Typing. Speed type definitions saved in a file whose name and location specified in Options general tab.

Speed typing allows to define strings which automatically expanded when typed. Speed typing is integrated in Intellisense and Auto complete. Speed typing also supports substitution parameters.

Examples:

1. Simple replacement. If Shortcut column contains sla and column Substitution Value contains SELECT * FROM then when you type sla in Script Editor and press space it will be replaced by SELECT * FROM

2. Use Speed typing to add Auto Complete strings. Simply enter desired string into Shortcut column and leave Substitution column blank

3. Using formal parameters:

If Shortcut column contains

sla (var_date, var_string)

and Substitution column contains

SELECT * FROM TABLE_NAME where date_col = '$(var_date)' and string_col = '$(var_string)'

then when in Script Editor you type:

sla (01/01/07, string_value)

it will be expanded into:

SELECT * FROM TABLE_NAME where date_col = '01/01/07' and string_col = 'string_value'

To specify cursor position in Editor after expansion put symbol '^' anywhere in substitution column text