Results 1 to 3 of 3

Thread: Ado [RESOLVED]

  1. Feb 14th, 2005, 09:54 AM #1
    mik706
    mik706 is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2002
    Location
    UK
    Posts
    147

    Resolved Ado [RESOLVED]

    With respect to ADO can somebody tell me the differance between Update and UpdateBatch
    Last edited by mik706; Feb 14th, 2005 at 10:16 AM.
    Mik706
    Reply With Quote Reply With Quote
  2. Feb 14th, 2005, 10:01 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Ado

    Easy... Update is used with connected recordsets (that still have an open & valid connection to the data source) to send the changes to the current record back to the database.
    UpdateBatch is primarily used with disconnected recordset to send a batch of updated back to the database (after it's been re-connected). I've done this a lot, get RS, diconnect it, perform data changes, reconnect and update batch. THe key to this one is when getting the recordset, amking sure it's opened with the batch operation setting on.

    Tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Feb 14th, 2005, 10:16 AM #3
    mik706
    mik706 is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2002
    Location
    UK
    Posts
    147

    Re: Ado

    Cheers techgnome
    Mik706
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width