Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. ADO recordset object

ADO recordset object

Scheduled Pinned Locked Moved C / C++ / MFC
database
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Shamoon
    wrote on last edited by
    #1

    After running the SQL query, we got rewsults the ADO recordset object. How can we retrieve the total number of records present in recordset object.

    S P 2 Replies Last reply
    0
    • S Shamoon

      After running the SQL query, we got rewsults the ADO recordset object. How can we retrieve the total number of records present in recordset object.

      S Offline
      S Offline
      Stefan Pedersen
      wrote on last edited by
      #2

      By searching the forums maybe? This was answered just a couple of days ago... Anyway, the record count (rs.Count) usually isn't valid until EOF has been seen, count reports the current number of seen records.

      1 Reply Last reply
      0
      • S Shamoon

        After running the SQL query, we got rewsults the ADO recordset object. How can we retrieve the total number of records present in recordset object.

        P Offline
        P Offline
        Prem Kumar
        wrote on last edited by
        #3

        If you are using static or keyset cursor then the recordset count you get from the property 'RecordCount" is valid else you need to go from record to record manually and then use the property.

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups