Database Viewer—Creating Result Tables

Complete the following steps to create the default result tables in a database.

  1. If you are continuing from the steps in the Database Options—Specifying a Data Link and Schema section, skip to step 2. Otherwise, complete the following steps.
    1. Launch the TestStand Sequence Editor and log in as Administrator.
    2. Select Configure»Result Processing to launch the Result Processing dialog box and click the icon in the Options column for the built-in database plug-in to launch the Database Options dialog box. The Logging Options tab is active.
    3. Enable database logging by removing the checkmark in the Disable Database Logging option.
    4. Click the Data Link tab of the Database Options dialog box.
  2. Click the View Data button to launch the Database Viewer application and open the data link.
    Note The Connection String Expression must contain a valid expression to launch the Database Viewer application.
  3. In the Database Viewer application, select File»Execute SQL Window to open an Execute SQL window.
  4. Click the Load From SQL File button.
  5. Select <TestStand>\Components\Models\TestStandModels\Database\Access Create Generic Recordset Result Tables.sql and click Open. Notice that the SQL Commands control now contains a set of SQL commands for creating the default result tables.
  6. Click the Execute button to create the default result tables.
  7. Review the results of the SQL commands on the Output tab to ensure that you created the tables successfully.
  8. Click the Refresh button in the Database Explorer pane to view the created tables.

After you have completed these steps, any execution you launch with the Test UUTs or Single Pass Execution entry point automatically logs results to the database.