希望懂vb的朋友进来!关于判断数据库中的数据是否相等的问题!!!!就有点急!!
Public Function cmpdata(rsSource As ADODB.Recordset, rsdes1 As ADODB.Recordset) As Boolean
Dim strsource As String
Dim strdes As String
Dim i As Integer
Dim flag As Boolean
Dim check() As Boolean
ReDim check(rsSource.Fields.Count - 1) As Boolean
For i = 0 To rsSource.Fields.Count - 1
If Not IsNull(rsSource(rsSource(i).Name)) And Not IsNull(rsdes1(rsSource(i).Name)) Then
If rsSource(rsSource(i).Name) <> rsdes1(rsSource(i).Name) Then
check(i) = True
Else
check(i) = False
End If
Else
check(i) = True
End If
Next
For i = 0 To rsSource.Fields.Count - 1
flag = check(i)
Next
cmpdata = flag
End Function
这些代码无法正确判断出两个数据库的数据是否一致。两个数据库的表都是一样的