Recordset count

Results 1 to 3 of 3

Thread: Recordset count

  1. #1
    Espen ( Guest

    Default Recordset count

    When I do a Recordeset.RecordCount I only get the value -1. Why does this happen ?<BR><BR><BR>Thnx<BR><BR>Espen

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset count

    Only certain recordset cursors support the .RecordCount property. The ForwardOnly database cursor, which is the default database cursor, DOES NOT support this property, and hence returns a -1.<BR><BR>What you can do:<BR>* Use the correct database cursor (either an OpenStatic, OpenDynamic, or OpenKeyset): see this article for more information (<BR><BR>* Use a SELECT COUNT(*) FROM TableName<BR><BR>There are ways you SHOULDN&#039T determine the # of records. For more information on how NOT to count the records in a recordset, check out:<BR><BR><BR>Happy Programming!

  3. #3
    Espen ( Guest

    Default RE: Recordset count

    So, acording to, the proper cursortype would be 3 then ? Like: Recordset.CursorType = 3<BR><BR><BR>Espen

Posting Permissions

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