Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











METHOD:  Recordset::CancelBatch
recordsetobject.CancelBatch  AffectRecords

The CancelBatch method is called to cancel a pending batch update. The Recordset must be in batch update mode, otherwise an error will occur.

Since you cannot predict what the current record will be after calling this property, you will need to move to a known record. For example, you could call the MoveFirst method, after the call to the CancelBatch method is completed.

If the attempt to cancel the pending updates fails, the provider does not halt execution, but it will send warnings to the Errors Collection. Therefore you should always check the Errors Collection after the call to the CancelBatch method is completed.

There is one optional parameter.

The optional AffectRecords parameter is one of the AffectEnum constants that specifies which records are to be affected.

AffectEnum Constants
 
Constant Value Description
adAffectAll 3 Cancels all pending updates including those hidden by a filter
adAffectAllChapters 4 Cancels all pending updates in all child (chapter) recordsets
adAffectCurrent 1 Cancels only the current record
adAffectGroup 2 Cancels updates only on records that passed through the filter in effect

 
Code (VBScript):
If MsgBox("Batch Save All Changes", vbYesNo) = vbYes Then
   objRecordset.UpdateBatch
   MsgBox "All Changes Updated"
Else
   objRecordset.CancelBatch
   MsgBox "All Changes Cancelled"
End If

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information