ADO Acara WillChangeRecord dan RecordChangeComplete
Referensi Objek Recordset Lengkap
Acara WillChangeRecord
Acara WillChangeRecord dipicu sebelum satu atau beberapa catatan berubah.
Catatan: Sebelum peristiwa ini kembali, setel parameter status ke adStatusCancel untuk membatalkan operasi yang menyebabkan peristiwa ini atau setel ke adStatusUnwantedEvent untuk mencegah pemberitahuan berikutnya.
Acara RecordChangeComplete
Acara RecordChangeComplete dipicu setelah satu atau beberapa catatan diubah.
Catatan: Sebelum metode ini kembali, setel parameter status ke adStatusUnwantedEvent untuk mencegah notifikasi berikutnya.
Catatan: Acara WillChangeRecord atau acara RecordChangeComplete dapat terjadi jika Anda mengubah bidang dalam catatan menggunakan salah satu dari operasi Recordset berikut: Perbarui, Hapus, CancelUpdate, AddNew, UpdateBatch, dan CancelBatch.
Sintaksis
WillChangeRecord reason,numrec,status,objRs
RecordChangeComplete reason,numrec,objErr,status,objRs
| Parameter | Description |
|---|---|
| reason | An EventReasonEnum value that specifies the reason for this event |
| numrec | Indicates the number of records affected |
| status | An EventStatusEnum value that indicates the status of the execution of the event |
| objErr | The name of an Error object that describes the error if status is set to adStatusErrorsOccurred, otherwise it is not set |
| objRs | The name of the Recordset Object that triggered this event |
EventReasonEnum Values
| Constant | Value | Description |
|---|---|---|
| adRsnAddNew | 1 | An operation added a new record |
| adRsnDelete | 2 | An operation deleted a record |
| adRsnUpdate | 3 | An operation updated an existing record |
| adRsnUndoUpdate | 4 | An operation reversed the update of a record |
| adRsnUndoAddNew | 5 | An operation reversed the addition of a new record |
| adRsnUndoDelete | 6 | An operation reversed the deletion of a record |
| adRsnFirstChange | 11 | An operation made the first change to a record |
Nilai EventStatusEnum
| Constant | Value | Description |
|---|---|---|
| adStatusOK | 1 | The operation that caused the event was successful |
| adStatusErrorsOccurred | 2 | The operation that caused the event failed |
| adStatusCantDeny | 3 | The operation that caused the event cannot be cancelled |
| adStatusCancel | 4 | The operation that caused the event is cancelled |
| adStatusUnwantedEvent | 5 | Prevents subsequent notifications before the event method has finished executing |
Referensi Objek Recordset Lengkap