Please visit our sponsors !
The 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.
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) |
Jump to: Top of Page
or HOME or
Printer friendly page
Search W3Schools:
What Others Say About Us
Does the world know about us? Check out these places:
Dogpile
Alta Vista
MSN
Google
Excite
Lycos
Yahoo
Ask Jeeves
We Help You For Free. You Can Help Us!
W3Schools is for training only. We do not warrant its correctness or its fitness for use.
The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our
terms of use and
privacy policy.
Copyright 1999-2002 by Refsnes Data. All Rights Reserved
|