METHOD:  DataControl::CancelUpdate

datacontrolobject.CancelUpdate

The CancelUpdate method is used to cancel and discard all pending changes made to the source recordset since the last Refresh or SubmitChange method call. This method resets the local cache containing the pending changes to empty.

Since ADO stores the data separate from the pending changes, you simply revert back to the previous set of data as it existed in the Recordset after the last update or call to Refresh.

You can use buttons on a Web page to navigate and manipulate a displayed recordset. For example, when the appropriate button is clicked, you can call a subroutine containing either this method or the SubmitChanges method:

Code (VBScript):
Sub SubmitChange_OnClick
   objDataControl.SubmitChanges
   objDataControl.Refresh
End Sub

Sub CancelUpdate_OnClick
   objDataControl.CancelUpdate
   objDataControl.Refresh
End Sub

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