NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Call stored procedure from TestStand

My application is working closely with an SQL database. Now I would like to call a stored
procedure within the db and retrieve the results, using the built-in database steps. My
SP expects one string parameter and returns two integers, arranged in two unnamed columns.
 
/Stefan
0 Kudos
Message 1 of 2
(3,308 Views)
Hello Stefan!
 
Please look at the following forum posts that discuss how to call stored procedures from TestStand.
 
How do I get return parameters from a stored procedure call? 
http://forums.ni.com/ni/board/message?board.id=330&message.id=1046&requireLogin=False
Can I Run My Microsoft Access Database Macros from Inside an Open SQL Statement Step in TestStand?
http://digital.ni.com/public.nsf/websearch/BB60DA9317C2F07086256BDC005E91B8?OpenDocument
 
Hope this helps since a few of them discusses this in more detail.
 
Regards,
Jimmie A.
Applications Engineer, National Instruments
Regards,
Jimmie Adolph
Systems Engineering Manager, National Instruments Northern European Region

0 Kudos
Message 2 of 2
(3,290 Views)