Properties Tab

The Properties tab contains the following options when you select Database in the Data Location ring control:

• Data Link Name —The name of the data link the dialog box uses to populate the Step Name Column ring control and to create columns. Click Select Data Link to select a predefined data link in the Select Data Link dialog box.
• Statement Handle (Number) —The name of the variable or property that contains the SQL statement handle the step uses to import values at run time. The variable or property is of the Number data type. Acquire a reference to a handle by calling an Open SQL Statement step.
• SQL SELECT Statement —The SQL statement the dialog box uses at edit time to create columns and populate ring controls that contain column names. The SQL SELECT Statement ring control contains a list of the Open SQL Statement steps in the current sequence file. TestStand will only populate the ring controls when the selected SQL Statement step uses a literal string or an expression that is valid at edit time.
• Step Name Column —The name of the SQL statement column that contains the names of the sequence steps and variable scopes that define the rows of data.
• Properties List Source —The name of the variable or property in which to store the property mappings the step performs. The variable or property must be a DatabasePropertyMapping array.
• Import to Run-time Sequence Only —Specifies whether the imported properties only affect the invocation of the currently running sequence, or whether the imported properties affect all future invocations of one or more sequences in a selected sequence file. When you import properties to the currently running sequence, you typically place the Property Loader step in the Setup step group for the sequence the step updates. When the import operation applies to all future invocations of sequences, you typically execute the Property Loader step before calling the selected sequences multiple times.
  Note If you disable this option, you must specify a valid sequence file and sequence. When the sequence you specify is the current sequence or when you specify <ALL SEQUENCES >, the step also applies the values to the run-time copy of the sequence.
  • Use Current Sequence File —Selects the file where the step is located.
  • Sequence File —The path of the sequence file into which to import variables and properties. Enable the Use Current Sequence File option to select the sequence file of the step. You must specify a valid sequence filename for the step to work properly.
  • Sequence —The name of the sequence into which to import variables and properties. The specified sequence must exist in the specified sequence file. Select the < ALL SEQUENCES > tag from the drop-down list to instruct TestStand to import variables and properties for all of the sequences in the specified sequence file. You must specify a valid sequence name for the step to work properly.
• Properties —The mapping of column names to variables or properties the step loads. The section contains two lists of variables and properties. The Available list control contains the properties and variables available in the selected sequence file and sequence. The Selected list control contains the properties and variables you select.

  Click the Limits> button to add all limit properties to the Selected list control.

  You can add one or more properties to the Selected list control by selecting items in the Available properties tree and clicking the single right arrow button (>). The double right arrow button (>>) adds all of the properties present in the Variables pane to the Selected list control.

  To deselect one or more properties, select them in the Selected list control and click the single left arrow button (<). Click the double left arrow button (<<) to remove all of the properties in the Selected list control.

  • Property Name —The currently selected property in the Selected list control.
  • Column Name/Number —The name or index of the column from which the step loads the property.
• Apply Imported Values to Related Executions —When you enable this option, the imported values are shared among related executions. Related executions include the original execution that the application and all subsequent executions TestStand invokes using a Sequence Call step initiates. For example, when you use the Batch process model, related executions include the following: the controlling execution, all test socket executions, and any additional executions these executions invoke.
• Append data type to column name —When you enable this control, TestStand automatically appends the name of the data type of a property to the column name for a property when you select a property from the Available list.
• Max size for column names —The maximum number of characters for a column name. Many databases limit the size of a column name. Use the ring control to select the limit for any DBMS TestStand supports by default.
• Create Columns —Launches the Create Columns dialog box. TestStand automatically populates the dialog box with the list of column names that you have selected but the SQL statement does not return. You typically use the Create Columns dialog box to add new columns to a database table for any newly selected properties.

Use the Expression Browse button to launch the Expression Browser dialog box for controls which contain TestStand expressions .

See Also

Create Columns dialog box

Expression Browser dialog box

Select Data Link dialog box