rslqk.CursorLocation = adUseServer
rslqk.Open "select * from lqk", database, , , adCmdText
Do While Not rslqk.EOF
Dim newstu As String
newstu = Trim(rslqk.Fields("ksh").Value)
rsbyk.CursorLocation = adUseServer
rsbyk.Open "select * from byk where ksh='& newstu &'", database, , , adCmdText
If rsbyk.EOF = True Then
rslqk.Fields("bz").Value = "无此毕业生" 'Trim(rslqk.Fields("bz").Value) +
rslqk.Update
rsbyk.Close
Else
rsbyk.Close
End If
rslqk.MoveNext
Loop
rslqk.Open "select * from lqk", database, , , adCmdText
Do While Not rslqk.EOF
Dim newstu As String
newstu = Trim(rslqk.Fields("ksh").Value)
rsbyk.CursorLocation = adUseServer
rsbyk.Open "select * from byk where ksh='& newstu &'", database, , , adCmdText
If rsbyk.EOF = True Then
rslqk.Fields("bz").Value = "无此毕业生" 'Trim(rslqk.Fields("bz").Value) +
rslqk.Update
rsbyk.Close
Else
rsbyk.Close
End If
rslqk.MoveNext
Loop
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货