Cancel Method
AddNew Method
CancelBatch Property
LockType Property
Update Method
UpdateBatch Method
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