02-16-2018 03:40 PM
Hi St3venA,
After reading some of the post I'm not entirely sure what you are looking for, but I believe this example may be of some assistance:
Retrieve Data in TestStand From an SQL Statement If Multiple Columns Have the Same Name
http://digital.ni.com/public.nsf/allkb/6F07F6CF24D0912586256E92007F6D08
If this is not what you are looking for. I would recommend creating a new post with exactly what you are looking for to help get me eyes on it, and help explain what you are looking for.
08-14-2019 07:31 AM
Your link goes directly to a page error.
07-10-2020 10:58 AM
I'm going through something similar, here's my thoughts:
Like somebody else said, check out this TS example:
C:\Users\Public\Documents\National Instruments\TestStand 2019 (32-bit)\Examples\Built-In Step Types\Database Step Types
I wanted to:
- Open the local access database.
- Get the ID of the last record.
- Close the local database.
Heres the steps to do that:
Open DB, Open SQL Query, Data Get, Close SQL Query, Close DB.
see the attached (TS2019) example. i suppose it wont be so useful as youll need the db schema also.. but you can atleast see the variables needed.