Metode Batch Pembaruan ADO
Referensi Objek Recordset Lengkap
Metode UpdateBatch digunakan untuk menyimpan semua perubahan dalam Recordset ke database. Metode ini digunakan saat Anda bekerja pada Recordset dalam mode pembaruan batch.
Jika operasi penyimpanan gagal, kesalahan run-time terjadi dan kesalahan disimpan dalam koleksi Kesalahan.
Tip: Metode CancelBatch membatalkan semua pembaruan batch.
Catatan: Tidak semua objek Recordset mendukung pembaruan batch.
Sintaksis
bool=objRecordset.UpdateBatch affectrecords
| Parameter | Description |
|---|---|
| affectrecords | Optional. An AffectEnum value
that specifies which records this method will affect.
Note: The value adAffectGroup will generate an error if there are no visible records in the Recordset |
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