Any reason for this??

Results 1 to 5 of 5

Thread: Any reason for this??

  1. #1
    Join Date
    Dec 1969

    Default Any reason for this??

    Any reason why rs.RecordCount would give me a -1 when I know the recordset contains two records?<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Any reason for this??

    Yes,<BR><BR>You may want to read more into recordsets, check the knowledge base. When I need a count, and that occurs, i prefer to use a database aggregate function (more overhead) but more accurate.<BR><BR>I do not remember the exact condition, but there is cases where you wouldn&#039t want to use the rs.recordcount. (sorry i don&#039t know more)

  3. #3
    sm549 Guest

    Default performance

    Check the help for ADO RecordCount. It describes the cursor types you can use to force ADO to count up the records for you. <BR><BR>Hope it helps.

  4. #4
    William Guest

    Default RE: Thanks. See this link

  5. #5
    Join Date
    Dec 1969

    Default RE: Any reason for this??

    because you are using an adOpenForwardOnly cursor type.<BR><BR>bart

Posting Permissions

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