LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to insert Cluster array of data into MS SQL database?

I've tried single cluster and it is ok but when i try to put array of clusters, I've got this error message.
                                                               
"Column name or number of supplied values does not match table definition."

I have used typed def. in some of cluster elements. But i have made it simple as "long" or "string" .... so it should be ok with database types.

any idea?
0 Kudos
Message 1 of 3
(4,252 Views)
first keep the insert database vi in the for loop as it does not take the array inputs of cluster ,when you keep it inside the for loop then all the values will go as you desired  .also the column names should be without any spaces & the cluster from which you are inputting the data should have all the field of the database
thanks
Message 2 of 3
(4,249 Views)
Thanks.... It works now... That's one of the reasons I love forums.ni.com 😛
0 Kudos
Message 3 of 3
(4,238 Views)