NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a user guide section for 'Data Operation'?

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.

0 Kudos
Message 11 of 13
(517 Views)

Your link goes directly to a page error. 

0 Kudos
Message 12 of 13
(442 Views)

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.

Sr Test Engineer at American Innovations - LabVIEW CLA - Kudo's are appreciated!!
0 Kudos
Message 13 of 13
(356 Views)