Legacy Database Plugins

The legacy database plugin contains the following plugin-specific options:

• SQL Select Statement — The SQL statement property loader plugin uses to import property and variable values. The SQL statement must return a recordset that includes the column names you specify.
• 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.
• 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 control to select the limit for any DBMS TestStand supports by default.
• 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.
• Only Import Rows that Match the Specified Column Values — When you enable this option, the step loads only the rows that match the specific column values. When you disable this control, the Column Values section is dimmed.
• Values — The column values that each row must match. The Name/Number, Value, and Format String controls specify the settings for the currently selected mapping. Use New, Cut, Copy, and Paste to create a new item in the list, remove items from the list, and rearrange the items in the list.
  • Name/Number — An expression TestStand evaluates at run time to determine the name of the column. To refer to a column by the order of the column in the SQL statement, specify an expression that returns a one-based number without surrounding quotes.
  • Value — An expression TestStand evaluates at run time to determine the filter value of a column. Include the <FILE> or <SEQUENCE> tag within a value expression to instruct TestStand to automatically substitute the name of the sequence or file on which the step operates. To insert the <FILE> or <SEQUENCE> tag, select it from the drop-down list.
  • 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.