LabVIEW Idea Exchange

cancel
Showing results for 
Search instead for 
Did you mean: 
Bushbandit

LABVIEW native way to Generate a list of User DB Stored _Procedures (any ADODB Compliant db)

Status: Declined

Any idea that has received less than 2 kudos within 2 years after posting will be automatically declined. 

Resolving an issue with calling MSSQL 2008 server side user stored_Procedures (or for that matter any other ADODB and user stored procedures) within Labview using the "LabVIEW DB Tools Create Parameterized Query VI."

 

This database toolkit vi will provide you the elements of a stored procedure provided you know the stored procedure name. 

 

HOWEVER to get the list of stored procedure names for a db current requires  user SQL coding and execution.

 

Could the functionality of the "LabVIEW DB Tools Create Parameterized Query VI." be extended to return the list (array) of the names of the held user stored_procedures..

 

See in code snippet

1. An example of the current method of getting list of user defined stored procedures

2. What I would like LabVIEW DB Tools Create Parameterized Query VI to provide is some command in (or set some flag) and return an array of user defined db stored_procedures names such as in the first code snippet from which I can then  pragmatically select as input to code snippet 3

3. The current implementation by which the "LabVIEW DB Tools Create Parameterized Query VI."  when given a stored procedure name returns a cluster of the parameter names and details of that stored procedure

 

MSSQL sp query.jpg

1 Comment
Darren
Proven Zealot
Status changed to: Declined

Any idea that has received less than 2 kudos within 2 years after posting will be automatically declined. 

DNatt, NI