Is there any way in the "Database Connectivity Toolset" to update a record in a database in a similar style as the "select Data" vi and the "insert Data" vi or are you supposed to use SQL statements?
I don't think there are any built in VIs that will allow you to replace/update a record. You will probably still want to go with the UPDATE SQL command.