mysql NO_AUTO_VALUE_ON_ZERO problem
Posted
by every_answer_gets_a_point
on Stack Overflow
See other posts from Stack Overflow
or by every_answer_gets_a_point
Published on 2010-05-13T00:00:58Z
Indexed on
2010/05/13
0:04 UTC
Read the original article
Hit count: 127
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?
© Stack Overflow or respective owner
