求教下recordset打开游标类型和锁定类型区别
游标类型中有四种类型,不是太清楚怎么应用
1 adopenforwardonly 这种是不是只能单向移动,movenext,不能向前moveprevious?假如我需要前后都能移动用哪一种?是adopendynamic?
2 锁定类型也有四种
我需要更改记录,然后立即更新,如下面的例子中
Set rs = QueryExt("select * from " & PartName & "_CMM_Info where Measure_ID='" & MeasureID & "'")
rs.Fields("FunDim_Pass_Rate") = FPR
rs.Fields("FunDim_Pass_Num") = b
rs.Fields("FunDim_Pass_Con") = c
rs.Fields("FunDim_Pass_No") = a
rs.Fields("GenDim_Pass_Rate") = GPR
rs.Fields("GenDim_Pass_Num") = f
rs.Fields("GenDim_Pass_Con") = g
rs.Fields("GenDim_Pass_No") = e
rs.Update
应该那种锁定类型,是adlockoptimistic?
[解决办法]
http://www.yesky.com/imagesnew/software/ado/html/mdmthupdatebatch.htm