 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / September 2006ADO test for empty recordset
How do i test a recordset before using the fields? Can you simply test for If not (rst.eof) and not (rst.bof) then debug.print rst.fields(0) End If My only concern with this test is that I don't know if a recordset can open at EOF or BOF even if it's not empty. I only want to skip empty recordsets to avoid errors. My recordset is a SQL query.  SignatureBilly Rogers Dallas,TX Currently Using Office 2000 and Office 2003 What you've got is the appropriate check. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > How do i test a recordset before using the fields? Can you simply test > for [quoted text clipped - 10 lines] > recordsets > to avoid errors. My recordset is a SQL query. Hi, yes, this is a right approach SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > How do i test a recordset before using the fields? Can you simply test > for [quoted text clipped - 10 lines] > recordsets > to avoid errors. My recordset is a SQL query. > How do i test a recordset before using the fields? Can you simply > test for [quoted text clipped - 8 lines] > can open at EOF or BOF even if it's not empty. I only want to skip > empty recordsets to avoid errors. My recordset is a SQL query. If you *know* the recordset has just been opened, then you need only check for either rst.EOF or rst.BOF. The recordset will be opened at the first record, if there are any records in it. However, if there's any question that the recordset's current record pointer may have been moved since it was opened -- and especially if you've just been handed a recordset from somewhere -- checking for both conditions is the right way to do it. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.