Click Build on the SQL Statement tab of the Edit Open SQL Statement dialog box to launch the Build SQL Select Statement dialog box.

The Build SQL Select Statement dialog box contains the following options:

• Data Link Name —Indicates the name of the data link to use to populate the Table and Column ring controls. Click Select Data Link to select a predefined data link in the Select Data Link dialog box. When you select a data link, TestStand automatically updates the Table and Column ring controls in the Add/Remove Columns section.
• Add/Remove Columns —Select the tables and columns to include in the SQL SELECT statement. TestStand populates the Table ring control with the tables the selected data link defines. When you select a table in the Table ring control, TestStand populates the Column ring control with a list of all columns in the table. When you want to select all columns in the SQL statement, choose the * item in the Column control.

Use the Add button to insert the selected table and column into the Table and Column list control. You can remove an item from the list control by selecting the item you want to delete and clicking Remove . You can reorder the items in the list control by selecting an item and clicking the up or down arrow buttons.

• Where Clause —An SQL WHERE clause to include in the SQL SELECT statement. You can specify a literal string or an expression TestStand evaluates at run time. Refer to Structured Query Language (SQL) for an overview of SQL commands. Click the Expression Browse button to launch the Expression Browser dialog box.

See Also

Data Link Properties dialog box

Edit Open SQL Statement dialog box

Expression Browser dialog box

Select Data Link dialog box

Structured Query Language (SQL)