Compiling SQL

When you select the Result tab, the defined SQL statement will be compiled. Record-set is displayed in case of successful completion. If there are errors, they are displayed in the same tab. This would help you in finding the exact location of error(s) and rectify them before using the SQL results in the Layout Designer.

Figure 11: SQL Compilation

If the SQL has used a parameter, you will be prompted to provide the values of the parameter.

Viewing SQL Results

The Result tab will display the result based on the SQL statement in the Edit tab. If the SQL statement has used a parameter, you will be prompted to provide the values while viewing the results.

Figure 12: SQL Results