adoRSetUpdBatch
Previous Topic  Next Topic 

Synopsis:

       adoRSetUpdBatch(handle,affected)

Arguments:

       handle - The recordset handle.


Description:   This function allows multiple changes to one or more records to be cached locally until you call the adoRSetUpdBatch() function.     If you are editing the current record or adding a new record when you call the adoRSetUpdBatch() function method, ADO will automatically call and  Update method to save any pending changes to the current record before transmitting the batched changes to the provider.    Batch updating should be used with either a keyset or static cursor only and the lock type should be adLockBatchOptimistic.


If the attempt to transmit changes fails for any or all records because of a conflict with the underlying data (for example, a record has already been deleted by another user), the provider returns warnings to the Errors collection and a run-time error occurs.  


Returns:   Returns 0 upon success or a negative error code.   If ADOERR_COMERR is returned, then the underlying ADO error can be obtained by calling adoLastError()