If rs.State = adStateOpen Then rs.Close Else searchstr="SELECT * FROM TABLENAME WHERE FIELDS(I)='" & stringarray(0) & " rs.Open searchstr, cn, 2, 3 IF RS.BOF AND RS.EOF THEN rs.AddNew For i = 0 To UBound(stringarray)-1 rs.Fields(i) = stringarray(i) Next ELSE For i = 1 To UBound(stringarray)-1 rs.Fields(i) = stringarray(i) Next rs.Update ENDIF
错了不好意思! If rs.State = adStateOpen Then rs.Close Else searchstr="SELECT * FROM TABLENAME WHERE FIELDS(I)='" & stringarray(0) & " rs.Open searchstr, cn, 2, 3 IF RS.BOF AND RS.EOF THEN rs.AddNew For i = 0 To UBound(stringarray)-1 rs.Fields(i) = stringarray(i) Next ELSE For i = 1 To UBound(stringarray)-1 rs.Fields(i) = stringarray(i) Next endif rs.Update ENDIF
而且VB里面的addnew,update,只支持动态游标!!
If rs.State = adStateOpen Then
rs.Close
Else
searchstr="SELECT * FROM TABLENAME WHERE FIELDS(I)='" & stringarray(0) & "
rs.Open searchstr, cn, 2, 3
IF RS.BOF AND RS.EOF THEN
rs.AddNew
For i = 0 To UBound(stringarray)-1
rs.Fields(i) = stringarray(i)
Next
ELSE
For i = 1 To UBound(stringarray)-1
rs.Fields(i) = stringarray(i)
Next
rs.Update
ENDIF
If rs.State = adStateOpen Then
rs.Close
Else
searchstr="SELECT * FROM TABLENAME WHERE FIELDS(I)='" & stringarray(0) & "
rs.Open searchstr, cn, 2, 3
IF RS.BOF AND RS.EOF THEN
rs.AddNew
For i = 0 To UBound(stringarray)-1
rs.Fields(i) = stringarray(i)
Next
ELSE
For i = 1 To UBound(stringarray)-1
rs.Fields(i) = stringarray(i)
Next
endif
rs.Update
ENDIF