经过INNER JOIN连接的两个数据表,生成的数据集在使用中,是否不能rs.UpdateBatch命令 sql = "SELECT Flange.*.FlangeNo,FlangeID.ID FROM flange " + _
"INNER JOIN FlangeID " + _
"ON Flange.Dn = FlangeID.Dn and Flange.Pn = FlangeID.Pn"
rs.StayInSync = True
rs.LockType = adLockBatchOptimistic
' 打开游标
rs.Open sql, conn rs.MoveFirst
For ii = 1 To rs.RecordCount
rs!FlangeNo = rs!id
'rs.UpdateBatch adAffectAllChapters
这条语句出错.
rs.MoveNext
Next ii我分析,两个数据表连接后,rs应该是个临时表,所以'rs.UpdateBatch adAffectAllChapters不能进行更新操作.
"INNER JOIN FlangeID " + _
"ON Flange.Dn = FlangeID.Dn and Flange.Pn = FlangeID.Pn"
rs.StayInSync = True
rs.LockType = adLockBatchOptimistic
' 打开游标
rs.Open sql, conn rs.MoveFirst
For ii = 1 To rs.RecordCount
rs!FlangeNo = rs!id
'rs.UpdateBatch adAffectAllChapters
这条语句出错.
rs.MoveNext
Next ii我分析,两个数据表连接后,rs应该是个临时表,所以'rs.UpdateBatch adAffectAllChapters不能进行更新操作.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货