同样是判断“表中有记录”的语句,请问这四句有什么区别没?
① if rs.eof = false then...
② if not rs.eof then...
③ if not rs.eof and not rs.bof then...
④ if rs.recordCount <> 0 then...
[解决办法]
'移动记录指针
if not rs.bof then rs.moveprevious
if not rs.eof then rs.movenext
if rs.recordcount>0 then rs.movefirst
查询
Rs.Find "custid = " & Chr(39) & SchData & Chr(39)
If Not Rs.EOF Then FindCust = True