LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I update a column in SQL using a different sized bundle?

Two columns are going to have 50,000, then the next two columns are going to have only about 7, and the last two will also have about 50,000. I'm only concerned about the Serial_Numbers column for now, not the Parts_List column. How do I insert 7 elements coming from a string array(shown in VI circled in red) into the 3rd column?

 

Thanks in advance,

Michael

almostdone.png

0 Kudos
Message 1 of 3
(2,452 Views)

bump

0 Kudos
Message 2 of 3
(2,423 Views)

For the VI you are using you would need to enter the contents of the WHERE clause for the condition. The VI itself will build the SQL statement so you are just providing it with the details. To be honest I don't use these VIs. All of our SQL actions are accomplished using stored procedures so we simply call the Execute Query VI. Your question is much more about SQL than it is about LabVIEW and without knowing your schema it is difficult to really give you specific advice.



Mark Yedinak
Certified LabVIEW Architect
LabVIEW Champion

"Does anyone know where the love of God goes when the waves turn the minutes to hours?"
Wreck of the Edmund Fitzgerald - Gordon Lightfoot
0 Kudos
Message 3 of 3
(2,417 Views)