Additional Columns Tab

When you export to a database, the Additional Columns tab defines the set of column values TestStand writes to the database for each record. When you import from a database, the tab defines the column values that a record must match before TestStand loads values from the record.

The option at the top of the tab enables the controls on the Additional Columns tab. The Additional Columns tab for database locations contains the following options:

• Values —The mappings of column names to variables or properties. The list control displays the mappings. Use the New , Cut , Copy , and Paste buttons to create a new item in the list, remove items from the list, and rearrange the items in the list.
  • Name/Number —A literal value or an expression TestStand evaluates during import and export. Use this control to specify the column for the currently selected mapping. For export, the column that corresponds to a property that contains a signed 64-bit integer must be BIGINT , NUMERIC , or DECIMAL with a precision of 19 and a scale of 0, and the column that corresponds to a property that contains an unsigned 64-bit integer must be BIGINT , NUMERIC , or DECIMAL with a precision of 20 and a scale of 0.
  • Value —A literal value or an expression TestStand evaluates during import and export. When importing values, this control must contain the name of a variable or property.

    Include the <FILE> or <SEQUENCE> tag within a value to instruct TestStand to automatically substitute the name of the sequence or file on which the step operates. Select <FILE> or <SEQUENCE> from the drop-down list to insert the tag.

  • Export NULL —When you enable this option, TestStand assigns NULL as the column value. When you enable this option, the Value expression is ignored and NULL is assigned to the corresponding column. This option only affects the exporting process.
  • Format String —Specifies how to convert a string value when comparing a column value to a string expression. Typically, you use this control when comparing data from a column that is of the date/time or currency type.
• 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.

Click the Expression Browse button to launch the Expression Browser dialog box for controls that contain a TestStand expression.

See Also

Create Columns dialog box

Expression Browser dialog box

Format Strings for Database Date Values