This Document is not yet Rated

Rate this Document

Implementing "Update Table" Functionality with the DB Connnectivity Toolkit.

Primary Software: LabVIEW Development Systems>>LabVIEW Professional Development System
Primary Software Version: 1.0
Primary Software Fixed Version: 7.1
Secondary Software: LabVIEW Toolkits>>Enterprise Connectivity Toolset

Problem:
The Database Connectivity Toolkit of LabVIEW does not provide me with the API to update a certain table as I could using SQL.

Solution:
There are two solutions to this

1. You could directly interface SQL calls with LabVIEW using the SQL call node, wherein you could parse a string like Update XYZ where...

2. The second solution is to add a library to your LabVIEW\vi.lib directory to your DB Connectivity folder, where the llbs for the other functions are stored.  This library has been made to add the Update functionality to your LabVIEW.The name of this library is Updatex.llb.

Once the Updatex.llb library is installed, you can run the attached program properly.  The DB Update Example.vi demonstrates how to update tables in a database without using SQL calls.

Related Links:

Attachments:


- UpdateEx.llb
- DB Update Example.vi



Report Date: 09/04/2005
Last Updated: 01/17/2008
Document ID: 3P3MD0N6

Your Feedback!	Poor  |  Excellent							Yes	No
Document Quality?							Answered Your Question?
	1	2	3	4	5
Document needs work? Please tell us why.
Please Contact NI for all product and support inquiries.