difference between cn.execute and rs.update?
- by every_answer_gets_a_point
i am connecting to mysql from excel using odbc. the following illustrates how i am updating the rs
With rs
.AddNew ' create a new record
' add values to each field in the record
.Fields("datapath") = dpath
.Fields("analysistime") = atime
.Fields("reporttime") = rtime
.Fields("lastcalib") = lcalib
.Fields("analystname") = aname
.Fields("reportname") = rname
.Fields("batchstate") = "bstate"
.Fields("instrument") = "NA"
.Update ' stores the new record
End With
the question is why is there a need to run cn.execute after this? havent i already updated the rs with rs.update?