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
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a fully functional free 30-day trial today!
|
