How do i replace data in a database?

[fredde]

Im using the database toolkit and want to read data from a database, add a number to the data and put it back in the same row and column as I read it. How do I solve that? So far I have only been able to read the data, add the number and put it back in the end of the file. 😞

[Dennis_Knutson]

You modify an existing database record with the SQL command UPDATE. The general syntax is

UPDATE table_name [options] SET col_name =expr,..
[WHERE clause]

I don't know if there's a specific VI for UPDATE in the toolkit but you should be able to execute any SQL command directly.