LabVIEW Idea Exchange

About LabVIEW Idea Exchange

Have a LabVIEW Idea?

  1. Browse by label or search in the LabVIEW Idea Exchange to see if your idea has previously been submitted. If your idea exists be sure to vote for the idea by giving it kudos to indicate your approval!
  2. If your idea has not been submitted click Post New Idea to submit a product idea to the LabVIEW Idea Exchange. Be sure to submit a separate post for each idea.
  3. Watch as the community gives your idea kudos and adds their input.
  4. As NI R&D considers the idea, they will change the idea status.
  5. Give kudos to other ideas that you would like to see in a future version of LabVIEW!
cancel
Showing results for 
Search instead for 
Did you mean: 
MGould

Add Support for Temporary Tables in the Database Connectivity Tool Kit

Status: Declined

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

Currently the Labview Database Tool Kit doesn't support returning or working with temp tables in a stored procedure.  This makes a SQL/Labview developer have to make complete hacks (such as returning tables in comma delimited form) to return results that take multiple table manipulations to generate.

 

See this thread for an example:

 

http://forums.ni.com/t5/LabVIEW/SQL-Query-Works-in-MS-SQL-Server-2008-but-not-when-using/m-p/2151492

 

3 Comments
Michael.Patterson
Member

Please add support for temp table return vales to the DB toolkit. I am finding that querys are duplicated and being written in unefficient ways to provide work around to be able to pass the data that Labview will be able to access. We have many existing querys that are used on our ERP system for reporting that we would like to access to automate in Manufacturing via Labview. I am having difficulty getting them rewritten by IT since they work fine with all other environments and have proven performance.

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
JonathanDC
Member

I would like to give this a kudos, but I can't since it has been declined.