mysql NO_AUTO_VALUE_ON_ZERO problem
- by every_answer_gets_a_point
at least i think that is what the problem is.
i am updating a mysql database through excel using an odbc like this:
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
besides the fields above, i also have a primary key auto_increment field called rowid
for some reason the only field that gets updated is instrument. none of the other fields get updated..
however, when i try to do the same updating on a table that has no ROWID auto_increment field, it works perfectly
has anyone else experienced this kind of issue before?