Create or edit SQL statements

During runtime, you can create or edit the SQL statement that is executed by the aaHistClientActiveDataGrid. This SQL statement is executed each time the aaHistClientActiveDataGrid is refreshed. If the SQL statement is invalid or if the refresh fails, the data grid is cleared, and an error message appears.

To create or edit a SQL statement

1. Right-click in the aaHistClientActiveDataGrid.

2. In the shortcut menu that appears, click SQL. The ActiveDataGrid Properties dialog box appears.

3. If the SQL tab is not already selected, click the SQL tab.

4. In the SQL statement window, create or edit the current SQL statement(s) that is executed.

5. To use a pre-configured template, click Templates. If not, go to Step 9.

   The Templates dialog box appears.

6. In the Description list, select the template that you want.

7. Click Select.

8. The pre-configured SQL statement syntax appears in the SQL statement(s) window. You can then modify the syntax (for example, change the tagname, start date, and end date).

9. To delete all of the text in the SQL statement window, click Clear.

10. To apply the changes, click Apply or OK.