Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Configure Options > Editor > Application Code

Application Code Options

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set application code options

Review the following for additional information:

Parameter Markers	Description
Prefix	Enter the character used to prefix a bind variable.
Suffix	Enter the character used to suffix a bind variable. This field can be blank.
Escape character	Enter the character used to escape a bind variable delimiter.
Code Conversion	Description
Language template	Select the programming language syntax to use when adding or removing code.
Variable name	Enter the variable name used when adding syntax to the code.
Line terminator	Enter the character used as the end-of-line terminator.
Escape character	Enter the character used to escape this template.
String delimiter	Enter the character used to separate character strings.
Statement terminator	Enter the character used as the statement terminator.s
Parameters	Description
%SqlVar%	This parameter is replaced with the value specified for “Variable Name”.
%SqlText%	This parameter is replaced with the first line of SQL. This line should only occur once per template.
%SqlTextNext%	This parameter is replaced with the second and subsequent lines of SQL. The line is substituted and repeated as many times as needed.
%EndLine%	This parameter is replaced with the value specified for “Line Terminator”.
%EndStmt%	This parameter is replaced with the value specified for “Statement terminator” .

To test a new template, click Apply and test the template in the Editor until you receive expected results.

Tips:

To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).
To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.