Name
Recordset.WillChangeRecord Event — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
WillChangeRecord(ByValadReasonAs ADODB.EventReasonEnum, _ ByValcRecordsAs Long, _adStatusAs ADODB.EventStatusEnum, _ ByValpRecordsetAs ADODB.Recordset)
The WillChangeRecord event is called before an operation changes one or more records in the Recordset object.
Arguments
-
adReason(EventStatusEnum) Indicates the reason for this event. Proper values for the
adReasonparameter are:adRsnAddNew,adRsnDelete,adRsnUpdate,adRsnUndoUpdate,adRsnUndoAddNew,adRsnUndoDelete, andadRsnFirstChange.
-
cRecords(Long) Indicates how many records are affected by the operation causing this event.
-
adStatus(EventStatusEnum) Indicates the status of the current operation. The
adStatusparameter is set toadStatusOKif the operation causing this event was successful. If theadStatusparameter is set toadStatusCantDeny, the event cannot request that the operation be canceled. If theadStatusparameter toadStatusUnwantedEvent, this event will not be called again. If theadStatusparameter is set toadStatusCancel, a cancellation request will be made for this operation.
-
pRecordset Represents the Recordset object that fired this event.
See Also
EventReasonEnum Enumeration, EventStatusEnum Enumeration, Recordset.AddNew Method, Recordset.CancelBatch Method, Recordset.CancelUpdate Method, Recordset.Delete Method, Recordset.RecordChangeComplete Event, Recordset.Update Method, Recordset.UpdateBatch Method
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access