CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2000
    Location
    Pakistan
    Posts
    2

    Disconnected Recordset

    I am using Disconnecting Recordset.I have created
    Disconneced recordset in a function which is in
    ActiveX dll.I Have received data from this recordset successfully and displayed it at client side. Problem is occured when i try to update the record.
    I am using ADOR recordset at client side.
    Please Help me with a sample code which contains
    properties of ADOR recordset beacuse I face failure in ADOR recordset (e,g)rs.fields(0).value=Text1.

    Life is Temporary

  2. #2
    Join Date
    Jan 2000
    Location
    MO, USA
    Posts
    1,506

    Re: Disconnected Recordset

    what's the error you are getting? what kind of recordset are you opening in the dll? if you open a readonly cursor in the dll and then return that to the client - yuo still can't update it. you'll have to open a dynamic cursor in the dll, send it back, do your updates (your example code is fine) and then send it back to the dll, and then back to the database.

    John

    John Pirkey
    MCSD
    http://www.ShallowWaterSystems.com
    http://www.stlvbug.org
    John Pirkey
    MCSD (VB6)
    http://www.stlvbug.org

  3. #3
    Join Date
    Jul 2000
    Location
    Pakistan
    Posts
    2

    Re: Disconnected Recordset

    Thanks for Helping.I was trying an un specified cursor.Now i have use Dynamic Cursor problem have solved.


    Life is Temporary

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured