rs.MoveFirst
date1 = rs!交接日期
t = DateDiff("d", date1, today)
i = 0
Do While rs!返回日期 = Null And DateDiff("d", date1, today) <= 15 And Not rs.EOF
i = i + 1
rs.MoveNext
Loop
我怎么最后返回的i值还是0阿。我数据库里满足条件的记录有很多阿!怎么循环没起作用呢?
...全文
4315打赏收藏
循环没起所用?
rs.MoveFirst date1 = rs!交接日期 t = DateDiff("d", date1, today) i = 0 Do While rs!返回日期 = Null And DateDiff("d", date1, today) <= 15 And Not rs.EOF i = i + 1 rs.MoveNext Loop 我怎么最后返回的i值还是0阿。我数据库里满足条件的记录有很多阿!怎么循环没起作用呢?
rs.MoveFirst
date1 = rs!交接日期
t = DateDiff("d", date1, today)
i = 0
Do While Not rs.EOF and not rs.bof
if rs!返回日期 = Null And DateDiff("d", date1, today) <= 15 then
i = i + 1
end if
rs.MoveNext
Loop
cnn.open......
dim thedate as date
thedate=dateadd("d",date(),-15)",
rs.open"select * from table where isnull(返回日期) and 交接日期 between thedate and date()",cnn,3,3
msgbox rs.recordcount