LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I write into a table cell (row, column are given) in a databae?

Solved!
Go to solution

How can I write into a table cell (row, column are given) in a database using LabVIEW Database Toolkit? I am using Ms Access. Suppose I have three columns in a table, I write 1st row of 1st column, then 1st row of 3rd column. The problem I am having is after writing the 1st row 1st column, the reference goes to second row and if I write into 3rd column, it goes to 2nd row 3rd column. Any suggestion? 

0 Kudos
Message 1 of 2
(2,739 Views)
Solution
Accepted by topic author mtitoo

When you do a SQL INSERT command, you create a new row. If you want to change an existing row, you have to use the UPDATE command (i.e. UPDATE tablename SET column = value WHERE some_column=some_value). The some_column could be the unique ID of each row, a date/time, etc.

 

I have no idea what function to use in the toolkit to execute a SQL command since I don't use the toolkit. I also don't understand why you just don't do a single INSERT. It would be much faster.

Message 2 of 2
(2,732 Views)