TestStand SQL Database Call Not Recorded into Variables

Updated Mar 26, 2018

Reported In

Software

  • TestStand

Issue Details

My test parameters are stored in an SQL table and my sequence file is intended to get initialization information from the test operator. Once the item number is entered I need to query the SQL table and return the corresponding record. My database connection is working and as far as I can tell my query is being executed. However, it seems to be returning 0 records even though I know the record exists in the table.

Solution

  • Ensure that you are following the proper procedure when making a SQL Call in TestStand using the Database Step Types.
  • In order to check whether the record is showing up in the Results container, we recommend setting a break point immediately after the Get Data Operation. Check the Results container to ensure that data is being captured correctly.

WAS THIS ARTICLE HELPFUL?

Not Helpful