方法一:
DataTables("ISO_Index").loadfilter = ""
DataTables("ISO_Index").loadTop = "100 percent"
DataTables("ISO_Index").load
msgbox(2)
For Each u As String In DataTables("ISO_Index").GetValues("Document_No")
If DataTables("ISO_Index").Compute("Count([_Identify])","Document_No = '" & u & "'") > 1 Then
Dim md As Date = DataTables("ISO_Index").Compute("Max(RecieveDate)","Document_No = '" & u & "'")
Dim dss As List(Of DataRow)
dss = DataTables("ISO_Index").Select("[Document_No] = '" & u & "'")
For i As Integer = 0 To dss.Count-1
If dss(i)("RecieveDate") < md Then
dss(i)("REV_Status") = "Updated"
Else
dss(i)("REV_Status") = "New"
End If
Next
End If
Next