ADO UpdateBatch Method
Complete Recordset Object Reference
The UpdateBatch method is used to save all changes in a Recordset to the database. This
method is used when you are working on a Recordset in batch update mode.
If the save operation fails, a
run-time error occurs and the errors are stored in the Errors collection.
Tip: The CancelBatch method cancels all batch updates.
Note: Not all Recordset objects supports batch updating.
Syntax
| bool=objRecordset.UpdateBatch affectrecords |
| Parameter |
Description |
| affectrecords |
Optional. An AffectEnum value
that specifies which records this method will affect.
Note: The value adAffectGroup will generate an error if there
are no visible records in the Recordset
|
AffectEnum Values
| Constant |
Value |
Description |
| adAffectCurrent |
1 |
Affects only the current record |
| adAffectGroup |
2 |
Affects only records that satisfy the Filter setting (Filter must be
set to a FilterGroupEnum
value or an array of Bookmarks) |
| adAffectAll |
3 |
Affects all records if there is no Filter. Affects only visible
records in the current chapter if Filter is set to a string criteria.
Affect all rows of the Recordset if Filter is set to a FilterGroupEnum
value or an array of Bookmarks
|
| adAffectAllChapters |
4 |
Affects all records in all child Recordset, including those hidden
by a currently applied filter |
Complete Recordset Object Reference
Create a free Flash website with our simple, online web design editing platform. Stunning templates
and user-friendly tools make website building easy and fun.
Start Creating your free website now!

The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|