[thelist] ASP/TSQL/UID

Means, Eric D eric.d.means at boeing.com
Wed Oct 2 11:49:01 CDT 2002

-----Original Message-----
From: Anthony Baratta [mailto:Anthony at Baratta.com]
Sent: Wednesday, October 02, 2002 11:44 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] ASP/TSQL/UID

> With ADO to test for an empty record set you check to see
> if the record set is at the begining and the end simultaneously.
> That condition is only true for empty record sets.

Yes, but doing so is often unnecessary in practice, because if a recordset
is empty then EOF will always be true anyway -- so a construction like
If Not (rs.EOF And rs.BOF) Then
  Do While Not rs.EOF
End If

Is functionally exactly equivalent to
Do While Not rs.EOF

The only time I can see checking both BOF and EOF is if you for some reason
need to report that no rows were returned.

More information about the thelist mailing list