Currently VB Make Code template adds "SQL =" to SQL code. User would like to change "SQL" to "s_SQL" . How to modify existing Make Code templates?
Version 8.6.1 and below:
1. Select View | Toad Options menu option
2. Select Editor | SQL/Procedure from left side tree
3. On the right, under Make Code section, select VB and hit Edit button
4. Change text and add "s_" to "SqlVar%" as such:
{VB Language Template}
s_%SqlVar% = " %SqlText% "
s_%SqlVar% = s_%SqlVar% & "%SqlTextNext% "
5. Hit OK to save changes
For version 9.0 and above:
1. Select View | Toad Options menu option
2. Select Editor | Code Assist from left side tree
3. On the right, under Make Code section, select VB and hit Edit button
4. Change text and add "s_" to "%SqlVar%" as such:
{VB Language Template}
s_%SqlVar% = " %SqlText% "
s_%SqlVar% = s_%SqlVar% & "%SqlTextNext% "
5. Hit OK to save changes
