Microsoft ActiveX Data ObjectsMicrosoft ActiveX Data Objects*
*Contents  *Index  *Topic Contents

CancelUpdate Method - ADO

Cancels any changes made to the current record or to a new record prior to calling the Update method.

Applies To

Recordset

Syntax

recordset.CancelUpdate

Remarks

Use the CancelUpdate method to cancel any changes made to the current record or to discard a newly added record. You cannot undo changes to the current record or to a new record after you call the Update method unless the changes are either part of a transaction that you can roll back with the RollbackTrans method or part of a batch update that you can cancel with the CancelBatch method.

If you are adding a new record when you call the CancelUpdate method, the record that was current prior to the AddNew call becomes the current record again.

If you have not changed the current record or added a new record, calling the CancelUpdate method generates an error.

Examples

Update and CancelUpdate Methods Example (VB)


Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.