[求助] sqlfind和find 显示结果不一样 Post By:2018/1/15 23:17:00 [只看该作者]
'期初余额为: 查找 "小于当前行" 和 "系统主卡编号"的行,并取值"余额",如果 If e.DataCol.name = "系统主卡编号" Then Dim dr1 As DataRow Dim dr2 As DataRow Dim mr As DataRow = e.DataRow dr1 = DataTables("主卡余额汇总流水").find("[_sortkey] < " & mr("_sortkey") & " And [系统主卡编号] = '" & mr("系统主卡编号") & "'","[_sortkey] desc") dr2 = DataTables("新增主卡明细").find("[系统主卡编号] = '" & mr("系统主卡编号") & "'") If dr1 Is Nothing Then mr("期初余额") = dr2("期初余额") Else mr("期初余额") = dr1("主卡余额") End If End If