ADO Resync Method
 Complete Recordset Object Reference
The Resync method refreshes the data in a Recordset.
Tip: Use this method to resynchronize the Recordset with the database.
If you want to see
changes in the database and you are using a static or forward-only Recordset,
this method is useful.
Note: This method does not re-execute the Recordset, so new records in the
database will NOT be visible.
Syntax
| objRecordset.Resync affectrecords,resyncvalues |
| Parameter |
Description |
| affectrecords |
Optional. An AffectEnum
value that specifies which records this method will
affect. Default is adAffectAll |
| resyncvalues |
Optional. A ResyncEnum value
that specifies if underlying values are overwritten. Default is adResyncAllValues |
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 |
ResyncEnum Values
| Constant |
Value |
Description |
| adResyncAllValues |
2 |
Default. Overwrites data, and pending updates are canceled |
| adResyncUnderlyingValues |
1 |
Does not overwrite data, and pending updates are not canceled |
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 development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- And much more!
Download a free trial today!
|
|
|
|
