ADO Recordset object >>Delete Method
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.
To use this method assure that the Recordset object
allows record deletion.
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
|
Example
bjRecordset.Delete
objRecordset.UpdateBatch
|
| 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) |
|