ADO WillChangeRecordset dan RecordsetChangeComplete Events
Referensi Objek Recordset Lengkap
Acara WillChangeRecordset
Acara WillChangeRecordset dipicu sebelum operasi mengubah Recordset.
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 RecordsetChangeComplete
Acara RecordsetChangeComplete dipicu setelah Recordset berubah.
Catatan: Sebelum peristiwa ini kembali, setel parameter status ke adStatusUnwantedEvent untuk mencegah pemberitahuan berikutnya.
Catatan: Event WillChangeRecordset dan RecordsetChangeComplete dapat terjadi saat memanggil metode Requery atau metode Open dari objek Recordset.
Sintaksis
WillChangeRecord reason,status,objRs
RecordsetChangeComplete reason,objErr,status,objRs
| Parameter | Description |
|---|---|
| reason | An EventReasonEnum value that specifies the reason for this event |
| 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 |
|---|---|---|
| adRsnRequery | 7 | An operation requeried the Recordset |
| adRsnResynch | 8 | An operation resynchronized the Recordset with the database |
| adRsnClose | 9 | An operation closed the Recordset |
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