From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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
(515 Views)

Your link goes directly to a page error. 

0 Kudos
Message 12 of 13
(440 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
(354 Views)