Output
One line per property - this option instructs ASE to generate the code placing each of the fields being retrieved on a separate line in the select statement. Some prefer this for easier readability.
Always use wildcard - it is not necessary to list each field when performing a select statement; a simple asterisk can be used to retrieve all fields even if your code will only address some of them. This keeps the generated code shorter and neater based on your own preference.
Describe properties - by selecting this option, when you choose "Read" as the action to be generated, each value returned will be preceded by a string indicating the field name. So instead of displaying simply, "<value>" for each field, the code created will display, "value: <value>" for each field.
Dim variables - If you prefer to declare all your variables, or enforce variable declaration in your code (Option Explicit), checking this box will result the inclusion of a Dim statement for the variables used by the code.
Action: This output option determines what the code for the fields you have specified should do. Valid options are:
Read (Select) to read the selected fields from the database and optionally display their names (see describe properties).
Add (Insert) to add a new record to the database. When choosing this option the generated code will start with code that specifies the names of a variable which corresponds to each field name. Populate the values of these variables to indicate what values the new record should include.
Modify (Update) to update an existing record based on the conditions specified (see below). Like the Add action, the generated code will start with code that specifies the names of a variable which corresponds to each field name. Populate the values of these variables to indicate what values the new record should include.
Conditionals
Here you may specify any conditions you wish to use in limiting the records returned by the generated code. The generated code is written to account for the return of multiple records by use of a loop statement. However, you may limit the records returned by specifying conditions here in the following format:
<field name> <condition> <value>
Note: you do not need to specify quotes for string values, ASE will see that the field is a string and automatically insert quotes as required.
Formatting
If you wish, this section allows you to specify the variable names for the connection, command and recordset variables.
When you are ready, simply press the "Insert" button to insert the specified code at the location of the cursor in the current script document. The language will be automatically determined by the language of this document. If an unsupported language is reflected in the current document, the "Insert" button will be disabled.