Properties Tab

The Properties tab for database locations contains the following options:

• Sequence —Selects the sequence to import values to or export values from.
• Step Name Column —The name of the column in the SQL statement that contains the names of the sequence steps and variable scopes that define the rows of data. Click the Expression Browse button to launch the Expression Browser dialog box.
• Properties —The names of the variables and properties to import or export. The Variables pane 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.

  To add one or more properties to the Selected list control, select the properties in the Available Properties tree and click the single right arrow button ( > ). Click the double right arrow button ( >> ) to add all of the properties present in the Available Properties tree 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. For array element properties, you must edit the property name to specify the array index. If you select a container or array property, TestStand stores the contents of the property as an XML stream.
  • Column Name/Number —The name or number of the column where the step imports or exports the property.
• Append data type to column name —When you enable this option, TestStand automatically appends the name of the data type for the 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 limits for the DBMS TestStand supports by default.
• Create Columns —Launches the Create Columns dialog box. TestStand automatically populates the dialog box with the list of any column names that you specify and the SQL statement does not return. You typically use the Create Columns dialog box to add new columns to a database table.

See Also

Create Columns dialog box

Expression Browser dialog box