METHOD:  Recordset::CancelUpdate

recordsetobject.CancelUpdate

The CancelUpdate method is called to cancel any pending changes made to the current record including a newly added record. This can only be done before the Update method is called. Afterwards is too late since the record is saved and has become part of the database. The previous record will become the new current record.

If no changes have occurred to the current record, then calling this method will generate an error.

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

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