????????Щ????д???????????????????????????????EOF??Endof File????BOF(Before of File)???????????????????????????????????????η???????????????????????????????

??????????

????BOF?????????λ??λ??Recordset??????????????

????EOF?????????λ??λ??Recordset???????????????

?????????????????????????????True??False?????BOF ?? EOF ???????? Recordset ????????????????????????????????????????????? Recordset ?????????? ?±???????????????????????? 

 

 

EOF

BOF

True

????е?λ?????????е???棬????

????е?λ??????????????????

False

????е?λ?????????л?????棬?м??

???λ?????????л?????м??

 

?????????

??????1???????????λ?????????????BOF ????????? True(-1)??????????????????????λ??????????? False (0)??

??????2???????????λ?? Recordset ??????????????? EOF ?????????True??????????? Recordset ??????????????λ????????????? False??

??????3????? BOF ?? EOF ????? True??????е???????

??????4?????????м???? Recordset ????BOF ?? EOF ??????????True???? Recordset ????? RecordCount ???????????????????????????? Recordset ??????????????????????????BOF ?? EOF ????? False??

??????5???????? Recordset ?????б?????????BOF ?? EOF????????? False????????°??????????

??????????????????????????У????漰?????????е?MoveFirst??MoveLast??MovePrevious??MoveNext????????????????????????????Recordset?е??????н??в????????????????MoveNext????????????У????EOF????????True

????????? EOF ????? True ?????? MoveNext ???? BOF????? True ?????? MovePrevious ?????????????????????‘3021’?????

?????????????????????Move ??????????ζ????÷??????????λ??С??????????????????? Move ???????????????????????????? BOF ?? EOF????????????????????????????

?????????÷?

????If objRs.BOF Then

????????????????λ?????????м????????...

????If objRs.EOF Then

????????????????λ?????????м???????...

????If Not objRs.EOF Then

????????????????λ????е??????????

????If Not objRs.BOF then

????????????????λ????е??????????

??????????????????

????If Not (objRs.BOF AND objRs.EOF) Then

????????????λ??RecordSet ????У??????????????????? ?????????м????

????If objRs.BOF AND objRs.EOF Then

?????????????κμ??