Been working on this and got some good results, again thanks for all the help provided.
Now I want to update a record where a text field equals a database entry.
ie update a field in a row
I get this error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (taskref) = ('666')' at line 1
Dim myconnection As New MySqlConnection(myConnString)
Dim command As New MySqlCommand("INSERT INTO test (end) VALUES (?end) WHERE (taskref) = (?taskref)", myconnection)