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
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
New features in Version 2010!
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
