how to write data to an existing database table in sql using array in lab view

[parii]

i am trying to write the data in an existing table in sql databse.but i dont know how to get it done .plz help me

[Yamaeda]

What have you tried? Post your vi and explain your issues.

/Y

[parii]

i trying to add a new item in my table named Screws in database .when i run this it shows error.help me solving it out.

[Yamaeda · Accepted solution]

The error text is clear: The number of columns doesn't match the data provided. Your Insert data only has 3 columns, how many are named in the Columns control?

It'd be easier if you attached the VI's with the controls set to the current values as Default.

/Y

[parii]

THANK YOU