ADO WillChangeField dan FieldChangeComplete Events
Referensi Objek Recordset Lengkap
Acara WillChangeField
Acara WillChangeField dipicu sebelum nilai satu atau beberapa Objek Bidang berubah.
Catatan: Sebelum peristiwa ini kembali, setel parameter status ke adStatusCancel untuk membatalkan operasi yang menyebabkan peristiwa ini.
Acara FieldChangeComplete
Acara FieldChangeComplete dipicu setelah nilai satu atau beberapa Objek Bidang telah diubah.
Catatan: Sebelum peristiwa ini kembali, setel parameter status ke adStatusUnwantedEvent untuk mencegah pemberitahuan berikutnya.
Catatan: Peristiwa WillChangeField dan peristiwa FieldChangeComplete dapat terjadi saat Anda menyetel properti Nilai dan memanggil metode Perbarui dengan parameter larik bidang dan nilai.
Sintaksis
WillChangeField numfields,fields,status,objRs
FieldChangeComplete numfields,fields,objErr,status,objRs
| Parameter | Description |
|---|---|
| numfields | The number of Field objects in fields |
| fields | An array that contains Field objects with changes |
| 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 |
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