下面if函数的那句有编译错误,应该怎样修改??Private Sub Command1_Click() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim sql As String Set cn = New ADODB.Connection cn.Open "provider=microsoft.jet.oledb.4.0;data source=E:\成绩\分数.mdb;" sql = "select * from 分数表" Set rs = New ADODB.Recordset Dim i as Integer rs.Open sql, cn, adOpenForwardOnly, adLockOptimistic while not rs!eof
if i <> 0 then i=rs.字段1-i rs.字段2=i end if i=rs.字段1 wend rs.update rs.Close cn.Close Set rs = Nothing Set cn = Nothing End Sub
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
Set cn = New ADODB.Connection
cn.Open "provider=microsoft.jet.oledb.4.0;data source=E:\成绩\分数.mdb;"
sql = "select * from 分数表"
Set rs = New ADODB.Recordset
Dim i as Integer
rs.Open sql, cn, adOpenForwardOnly, adLockOptimistic
while not rs!eof
if i <> 0 then
i=rs.字段1-i
rs.字段2=i
end if
i=rs.字段1
wend
rs.update
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub