[AccessD] Recordset question

Charlotte Foust cfoust at infostatsystems.com
Tue Aug 7 11:40:01 CDT 2007


Nope, with an ADO recordset, check for EOF and BOF (empty recordset).
Don't try a movefirst otherwise.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, August 07, 2007 5:53 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Recordset question

Given an ADODB recordset that has been opened, should one moveFirst and
then check for EOF, or vice-versa? Will it error if you moveFirst and
there are no records in the set?

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list