改为这样,比赛积分表红方日期改过来了,黑方没执行,依然弹出上面截图的报错。
Dim qsmc As WinForm.ComboBox = e.Form.Controls("棋赛名称")
Dim di1 As String = qsmc.Value
Dim m As WinForm.TextBox = e.Form.Controls("第几轮")
Dim di2 As String = m.Value
Dim bsrq As WinForm.DateTimePicker = e.Form.Controls("rq")
Dim di3 As Date = bsrq.Value
Dim fz As WinForm.ComboBox = e.Form.Controls("fenzhu")
Dim Str As String = fz.Value
For Each nr As Row In Tables("综合组").Rows
Dim dr As DataRow = DataTables("比赛积分").SQLfind("[棋赛名称] = '" & di1 & "' And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [编号] = '" & nr("红方_编号") & "'")
If di3 <> Nothing Then
dr("日期") = di3
End If
If dr IsNot Nothing Then
dr("桌号") = nr("桌号")
dr("红黑方") = "红方"
dr("积分") = nr("当前局成绩_红方")
dr.Save
End If
dr = DataTables("比赛积分").SQLfind("[棋赛名称] = '" & di1 & "' And [第几轮比赛] = '" & di2 & "' And [分组] = '" & Str & "' And [编号]='" & nr("黑方_编号") & "'")
If dr IsNot Nothing Then
dr("桌号") = nr("桌号")
dr("红黑方") = "黑方"
dr("积分") = nr("当前局成绩_黑方")
dr.Save
End If
Next
[此贴子已经被作者于2020/7/2 20:29:39编辑过]