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
 |
 |
 |
 |
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
 |
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
 |
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |

|
Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture |
 |
Promote collaboration in your organization through project workspaces where others can efficiently find information and work together |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
|
|
 |
TAKE THE VIDEO TOUR |
 |
or download a FREE TRIAL today. |
|