11-05-2012 03:42 PM - edited 11-05-2012 03:54 PM
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
11-06-2012 08:25 AM
bump
11-06-2012 10:15 AM
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.