How to add data to database (not a row)

[ATElearner]

I use "db tools insert data.vi" to add a new row to the table. What if I want to add individual data? For example, say I have a 2 column table. I want to add a to column A and maybe later add b to column B (or maybe just leave column B blank).

Thank you very much

[tst]

To insert your values to only some of the columns you need to use the columns input, as it says in the help for the VI.

If you later want to add data to that row, you will need to use the SQL command "Update". You can either wire an SQL statement directly into the DB Tools Execute Query VI or you can build a VI similar to Insert Data which will have an additional input for the SQL "where" clause, which decides which row it needs to update.

[ATElearner]

It works. Thanks.