Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Australia
    Posts
    26

    Unanswered: what is the best way to test for zero recordsets?

    hello!

    i have been doing it this way but i'm not too sure if i am doing it right:

    if rs.EOF = true and rs.BOF = true then
    'for nothing returned
    else
    'something returned
    end if


    thanks in advance!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Perfect. If you are using a client-side cursor, then you can use rs.Recordcount and depending on the database used you can determine x records returned. But if you are already using a recordset object and recordcount is not available, you are correct.

  3. #3
    Join Date
    May 2002
    Location
    Australia
    Posts
    26
    thanks!

    i think i know what a client side cursor is. i'd like to know what else is there.

    i'll work it out.

    HA HA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •