Metode Batch ADO Batch
Referensi Objek Recordset Lengkap
Metode CancelBatch membatalkan pembaruan batch. Recordset harus dalam mode pembaruan batch saat memanggil metode ini.
Karena Anda tidak tahu apa catatan saat ini setelah memanggil properti ini, Anda harus pindah ke catatan yang dikenal. Misalnya, Anda dapat memanggil metode MoveFirst atau MoveLast, setelah panggilan ke metode ini.
Jika metode ini gagal, penyedia tidak akan menghentikan eksekusi, tetapi akan mengirim peringatan ke Koleksi Kesalahan.
Sintaksis
objRecordset.CancelBatch affectrec
| Parameter | Description |
|---|---|
| affectrec | Optional. An AffectEnum value that indicates which records this method will affect |
Nilai AffectEnum
| Constant | Value | Description |
|---|---|---|
| adAffectCurrent | 1 | Affects only the current record |
| adAffectGroup | 2 | Affects only records that satisfy the Filter setting (Filter must be set to a FilterGroupEnum value or an array of Bookmarks) |
| adAffectAll | 3 | Affects all records if there is no Filter. Affects only visible records in the current chapter if Filter is set to a string criteria. Affect all rows of the Recordset if Filter is set to a FilterGroupEnum value or an array of Bookmarks |
| adAffectAllChapters | 4 | Affects all records in all child Recordset, including those hidden by a currently applied filter |
Referensi Objek Recordset Lengkap