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. Database & SysAdmin
  3. Database
  4. ADO recordset question

ADO recordset question

Scheduled Pinned Locked Moved Database
questioncom
3 Posts 2 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.
  • M Offline
    M Offline
    Mike Puddephat
    wrote on last edited by
    #1

    Is it possible to get a reference (pointer) to the actual data stored in a recordset, rather than a local copy? All the functions we have found return data by value. However, we want the fastest mechanism for getting at large volumes of data and so don't want to perform copies every time an item is accessed. Thanks in advance! Visit my website![^]

    V 1 Reply Last reply
    0
    • M Mike Puddephat

      Is it possible to get a reference (pointer) to the actual data stored in a recordset, rather than a local copy? All the functions we have found return data by value. However, we want the fastest mechanism for getting at large volumes of data and so don't want to perform copies every time an item is accessed. Thanks in advance! Visit my website![^]

      V Offline
      V Offline
      Vagif Abilov
      wrote on last edited by
      #2

      Connected recordset is the closest thing to actual data you can get. So if you have ADO Recordset object (not disconnected), you can call Update method to modify data. There is no way you can get a pointer to physical data. If you OLE DB directly (bypassing ADO), you can retrieve and modify data in a more efficient way. Vagif Abilov MCP (Visual C++) Oslo, Norway Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros. Tomasz Sowinski

      M 1 Reply Last reply
      0
      • V Vagif Abilov

        Connected recordset is the closest thing to actual data you can get. So if you have ADO Recordset object (not disconnected), you can call Update method to modify data. There is no way you can get a pointer to physical data. If you OLE DB directly (bypassing ADO), you can retrieve and modify data in a more efficient way. Vagif Abilov MCP (Visual C++) Oslo, Norway Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros. Tomasz Sowinski

        M Offline
        M Offline
        Mike Puddephat
        wrote on last edited by
        #3

        Thanks for your help, Vagif. It's a shame you can't get a pointer to the physical data. Nevermind. I guess your sig could say: ADO is for sissies. Real men use OLE DB. And the most hardcore types use only db library!!! :laugh::laugh: Cheers! Visit my website![^]

        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