Example Program Drafts

Showing results for 
Search instead for 
Did you mean: 

Insert Data into DataBase from an Array using LabVIEW Database Connectivity Toolkit LV 8.6

by Member smikel on ‎04-28-2009 12:57 PM

Overview

This VI inserts data into a database from an array in LabVIEW using the Database Connectivity Toolkit.


Description

  1. Uses a UDL file to open a connection to the desired database.
  2. Take the array information which you want to insert into the database and extracts the columns which you wish to insert.
  3. Opens a connection to the Database, inserts the data into the database, and closes the connection to the Database.

Steps to Implement or Execute Code

  1. Select the UDL file for the connection information to the desired database
  2. Set the desired Table Name and Columns
  3. Write the Data to insert into the Database in the Array
  4. Run this VI


Requirements to Run

Software

LabVIEW 8.6 or Later

Hardware

N/A

Additional Images

Block Diagram

insert data into DataBase.JPG

Additional Information

Use the DATABASE CREATION PROCEDURE.pdf available on http://decibel.ni.com/content/docs/DOC-4602

Comments
Member parii
Member

i do it but it shows error..no of coloumns does not equals to parameter .what does it means

Active Participant ijustlovemath
Active Participant

Perhaps you should see if the number of columns you're inserting is equal to the number of parameters you're inserting.