Right-clicking the select line on the left Query Builder panel and selecting Add New Expression Column as shown in Figure 3.38. There are right-click options under each object on the canvas, different options when right-clicking the object header on the canvas, and others. You can add your own subqueries and calculations. The final two buttons (Run Query in Threads and Allow Modify Query Results) pertain to how you would like to execute the SQL and possibly have the ability to change results from within the Query Builder environment.
If clicked down, the SQL text will be adjusted accordingly. The Add Schema Name to Tables and Add Table Names to Column buttons are also toggle buttons. The Ansi button is a toggle it will rewrite your SQL using ANSI join syntax if clicked.
ECHOLINK RECEIVER I5000 MASTER CODE UPDATE
Likewise, you can make changes to the diagram in the canvas and click the Update SQL button, and the changes will be made to your generated SQL. You can make changes to the SQL via typing or you can paste a SQL statement into this generated SQL area and click the Update Diagram button, and the diagram in the canvas will be updated. The Update Diagram and Update SQL can be useful buttons. FIGURE 3.37 Generated Query Panel control buttons