ADO Delete Method
Complete Recordset Object Reference
The Delete method is used to delete the current record or a group of records. After deleting
a record, the deleted record remains current until you move to a different record.
Note: If you are in batch update mode the deletion happens when you call the UpdateBatch
method.
Note: To use this method assure that the Recordset object allows record
deletion.
Note: If this method fails, the provider will not stop the execution,
but it will send a warning to the Errors Collection.
Syntax
objRecordset.Delete affectrecords
|
| Parameter |
Description |
| affectrecords |
An AffectEnum value that
specifies which records this method will delete. Default is
adAffectCurrent |
AffectEnum Values
| Constant |
Value |
Description |
| adAffectCurrent |
1 |
Deletes only the current record |
| adAffectGroup |
2 |
Deletes only records that satisfy the Filter setting (Filter must be
set to a FilterGroupEnum
value or an array of Bookmarks) |
Complete Recordset Object Reference
|