Change field in database

[gihlutax]

Is there a way to change (update) one field in a database?

So I have a 2D-array in the database and I know the index of the row and column of the field I want to change.

Another way is reading the 2D-array, changing the 2D-array deleting the 2D-array from the database and insert the new 2D-array in the database.

But I'm afraid this will make the program slow.

So I hope there is faster/easier way?

Thanks

[Dennis_Knutson · Accepted solution]

You would use the SQL UPDATE command.

http://www.w3schools.com/sql/sql_update.asp

[gihlutax]

OK I see, I now see the condition terminal on the update function of the connectivity toolkit, I did'nt see it 🙂