代码:
With moveRs
.Open "select * from " & tablemove & "", conser, adOpenDynamic, adLockOptimistic
.AddNew
!empid = strempid
!datetime = datetime
!machineno = lvcon.ListItems(i).SubItems(2)
.Update
.Close
.Open "select * from " & table & " where empid = " & strempid & " and DateTime = datetime and machineno = " & strmachineno & "", conser, adOpenDynamic, adLockOptimistic
.Delete
.UpdateBatch adAffectAllChapters
End With
moveRs.Close在一个数据库中添加成功,但却不能在另一个数据库中删除记录,什么原因?
With moveRs
.Open "select * from " & tablemove & "", conser, adOpenDynamic, adLockOptimistic
.AddNew
!empid = strempid
!datetime = datetime
!machineno = lvcon.ListItems(i).SubItems(2)
.Update
.Close
.Open "select * from " & table & " where empid = " & strempid & " and DateTime = datetime and machineno = " & strmachineno & "", conser, adOpenDynamic, adLockOptimistic
.Delete
.UpdateBatch adAffectAllChapters
End With
moveRs.Close在一个数据库中添加成功,但却不能在另一个数据库中删除记录,什么原因?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货