Empty recordset 1

[developer155]

How do I check for an empty recordset (when the quesry does nto return any records). When I do this I get an error that object reference was not set:
Do Until rs.EOF

I also get the same error when I do this:
If rs.Fields.FieldCount>0

thansk!

 

[chiph]

You can check to see if rs is set to null.

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first

 

[developer155]

Like this?
If rs Is NULL

 

[chiph]

This is the C# forum, so you'd say it like:

if (rs != null)
{
  while (!rs.Eof())
  {
    // Code to access each row here
  }
}

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first