Column/Parameter Values Tab - Edit Data Operation Dialog Box

Column/Parameter Values Tab

The Column/Parameter Values tab of the Edit Data Operations dialog box applies only to Get, Set, Set and Put, Execute, and Close operations you perform in a Data Operation step. You can use the Column/Parameter Values tab to specify the mapping between SQL columns and TestStand variables and properties.

  • For a Get operation, a mapping between a column and variable or property instructs TestStand to assign the column value to the variable or property.
  • For a Set operation, a mapping between a column and a variable or property instructs TestStand to assign the value of the variable or property to the column.
  • For an Execute operation, a mapping between a parameter and a variable or property instructs TestStand to create the parameter and assign the value of the variable or property to the parameter.
  • For a Close operation, a mapping between a parameter and a variable or property instructs TestStand to assign the parameter to the variable or property.

The Column List Source control on the Record/Operation tab specifies a variable or property that stores this mapping.

The Column/Parameter Values tab contains the following options:

  • Data Link Name —The name of a data link to open and query. The Edit Data Operations dialog box uses the data link to populate the ring control that contains column names. Click Select Data Link to select a predefined data link in the Select Data Link dialog box.
  • SQL Statement —The SQL Statement the Edit Data Operations dialog box uses to populate the ring control that contains column names. The SQL Statement ring control contains a list of the Open SQL Statement steps in the current sequence file. TestStand can populate the Name/Number ring control only when the selected SQL statement step uses a literal string or a valid expression.
  • Values —The mappings of column names to variables or properties. The list control displays the mappings. The Name/Number, Values, and Format String controls specify the settings for the currently selected mapping. 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. Use the Expression Browse button to launch the Expression Browser dialog box. The Values section contains the following options:
    • Name/Number —A valid expression TestStand evaluates at run time. Enter a one-based number without surrounding quotes to refer to a column by the order of the column in the SQL statement.
    • Direction —Defines the parameter information the Execute operation uses to create parameters. A parameter direction can be In, Out, In/Out, or a return value. This option is available only when you perform an Execute operation.
    • Type —Defines the data type of the parameter in the database. The data type of a parameter can be String, Number, Boolean, or Date/Time. You must specify a Format String value when the data type is Date/Time. This option is available only when you perform an Execute operation.
    • Size —The maximum size for a String parameter. This option is available only when you perform an Execute operation.
    • Value —A valid expression TestStand evaluates at run time. When the Data Operation step performs a Get or Close operation, the Value control must contain the name of a variable or property. When the Data Operation step performs a Set or Execute operation, the Value Control can contain a literal value or an expression TestStand evaluates at run time.
      • Convert Null to Default Value —Specifies to store an empty string value, zero numeric value, or False Boolean value when the step performs a Get operation and the column value is NULL . The option is available only when you perform a Get or Close operation.
      • Write Null —TestStand stores NULL for the column value when the step performs a Set operation. This option is available only when you perform a Set, Set and Put, or Execute operation.
    • Format String —Specifies how to convert a string value when assigning a string expression to a column or when assigning the value of a column to a string variable or property. Use this control when getting or setting data from a column that is of the date-time or currency type.
Note If a stored procedure returns a recordset, the recordset typically does not return column names. When you want to retrieve values from a recordset, you must specify the column number instead of the column name when you perform a Get operation.

See Also

Data Link Properties dialog box

Expression Browser dialog box

Format Strings for Database Date Values

Select Data Link dialog box