The Database Adapter Configurator provides the Expert mode, which enables you to enter SQL Statements directly.
To switch to Expert mode:
1. From the SQL Statement tab in the Database Adapter Configurator, click Expert mode (Figure 93) to open the Confirm prompt.
Figure 93. Expert Mode Confirmation
2. Click Yes to leave the default Wizard mode and enter the Expert mode, and the following SQL Statement dialog box appears, with the Wizard Mode button now enabled.
Figure 94. SQL Statement in Expert mode
3. You can manually modify the SQL Statement as required. You can still use variables for column values, but remember to precede the variable name with @. To leave the Expert mode, and return to the default Wizard mode, click the Wizard Mode button.
4. When you have completed entering the statement, click Variables in the Clauses panel to open the Variable Definitions dialog box, where you can automatically define all the variables specified in the statement (if those are not already defined). You must still specify the data type for each variable. In this example, the variable "@IDds" is used and this variable is displayed in the Variable Definitions dialog box.
5. You must now define the variable type. Select the variable, click Modify and define the data type in the Variable Editor dialog box as required.
