代码如下:
sql0 = "select 1 as projnum,[project number],[project name],[project credit],[project debit],[difference] from projectinfo"
rs0.Open sql0, db, 3, 3
Dim i As Integer
For i = 1 To rs0.RecordCount
rs0.Update "projnum", CStr(i) --报错
Next i错误信息:
Multi-step operation generated errors, check each step state value
sql0 = "select 1 as projnum,[project number],[project name],[project credit],[project debit],[difference] from projectinfo"
rs0.Open sql0, db, 3, 3
Dim i As Integer
For i = 1 To rs0.RecordCount
rs0.Update "projnum", CStr(i) --报错
Next i错误信息:
Multi-step operation generated errors, check each step state value
第一个3指adOpenStatic改为1 adopenkeyset
你的是静态的,怎么能更新记录呢?
rs0.Open sql0, db, 1, 3同样错误
For i = 1 To rs0.RecordCount
rs0.Update "projnum", i --报错
Next i应该设为什么类型呢?
你这是什么update法啊,解释一下。
你看改成rs0!字段=??
rs0l.update