Record/Operation Tab

The Record/Operation tab contains the following options:

• Statement Handle (Number) —The name of the Number variable or property that contains the SQL statement handle on which to operate.
• Operation —The operation the step performs on the selected record. Select one of the following options from the ring control:
  • Fetch – Fetch Record Only —No operation is performed on this record.
  • Set – Update Values in Record —Sets the values of the selected record. The Column List Source control contains the name of a variable or property that lists the assignments the step performs. Specify the assignments in the Column/Parameter Values tab. You must issue a Put operation to update the selected record with any pending change to the values of the record.
  • Get – Retrieve Values from Record —Gets the values from the selected record. The Column List Source control contains the name of a variable or property that lists the assignments the step performs. Specify the assignments in the Column/Parameter Values tab.
  • Put – Write Record to Database —Updates the selected record with any pending changes to the values of the record.
  • Delete – Remove Record from Database —Deletes the selected record from the database.
  • Set and Put – Update Values and Write Record —Equivalent to a Set operation that a Put operation follows.
  • Execute – Set Parameters and Execute —Creates and sets the parameters for an SQL statement and executes the statement. You only use this operation with SQL statements that require parameters. Subsequent Execute operations do not recreate the parameters. Instead, they only set the parameter values before executing the statement. The Column List Source control contains the name of a variable or property that lists the parameters the step creates or sets. Specify the assignments in the Column/Parameter Values tab.
    Note To retrieve the values of output parameters, use a separate Data Operation step that specifies a Close operation.
  • Close – Close and Get Output Parameters —Closes a previously executed SQL statement and retrieves the values of the specified parameters. Specify the assignments in the Column/Parameter Values tab.
• Column List Source —The name of the variable or property in which to store the list of mappings between SQL columns and TestStand variables or properties. The Column List Source variable or property must be a DatabaseColumnValue array.
• Record to Operate On —Specifies whether the step operates on the current record, fetches a new record, or creates a new record. Select one of the following options from the ring control:
  • New – Create New Record —Creates a new record and operate on this new record.
  • Current – Use Current Record —Operates on a record you previously fetched or created.
  • Next – Fetch Next Record —Fetches the next record for the SQL statement.
  • Previous – Fetch Previous Record —Fetches the previous record for the SQL statement.
  • Index – Fetch Record by Index —Fetches the record with the index you specify in the Record Index control.
• Record Index —A literal numeric value or a numeric expression TestStand evaluates at run time.

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

See Also

Expression Browser dialog box