老师，下面两种方式，哪种效率会更高呢？
Dim r60 As DataRow
r60 = DataTables("日记账").sqlfin d(" 日期 >= '" & d1 & "' and 日期 <= '" & d2 & "' And 卡号 = '" & dr("卡号") & "' and 账套 = '" & _zhangtao & "' and 操作者 = '" & _username & "' " , "[_sortkey]" )
r6("期初余额0") = r60("期初余额")
r6.save()
cmd.CommandText = " updat e {日记账} set 期初余额0 = 期初余额 where 账套 = '" & _zhangtao & "' and 操作者 = '" & _username & "' And ( 日期 >= '" & d1 & "' and 日期 <= '" & d2 & "' order by [_sortkey] ) " '
cmd.ExecuteNonQuery()
[此贴子已经被作者于2020/5/17 8:40:04编辑过]
加好友 
发短信
Post By：2020/5/17 7:41:00 [显示全部帖子]
