Select Edit Close SQL Statement in the context menu for the step to launch the Edit Close SQL Statement dialog box from the TestStand Sequence Editor or a TestStand User Interface . From a user interface, you can also click Edit Close SQL Statement on the General tab of the Step Properties dialog box.

The Edit Close SQL Statement dialog box contains the following option:

• Statement Handle (Number) —The name of the Number variable or property that contains which statement handle to be closed. After closing the statement handle, the step assigns a value of 0 to the variable or property.

Databases might return an error when you use a Close SQL Statement step if the statement has pending record changes. Commit the pending record by using a Data Operation step type configured to do a Put Record operation to resolve this issue.

See Also

Database Step Types

Step Properties dialog box