ADO » Recordset » Resync
- Syntax:
- recordsetobject.Resync AffectRecords, ResyncValues
- ResyncValues
- The optional ResyncValues parameter is one of the ResyncEnum constants that determines which values can be overwritten. The default is adResyncAllValues.
Refreshes the data in the current Recordset object by re-synchronizing records with the underlying (original) database.
The Resync method is used to re-fetch the data from the underlying data source and
to update (resynchronize) the values in the current Recordset.
Since this is not a re-query, new records in the database will not be added to the
Recordset.
If you call this method on a server-side Recordset, you will get an error.
Likewise, you cannot use this method on client-side, read-only Recordset objects.
If the call to this method fails because of conflicts with the underlying date (such as
a record having been deleted), warnings will be returned to the Errors Collection
and a run-time error will be generated.
This method has two optional parameters.
The optional AffectRecords parameter is one of
the AffectEnum constants that specifies which records are to be affected.
The default is adAffectAll.
AffectEnum Constants
| Constant | Value | Description |
|---|---|---|
| adAffectAll | 3 | Cancels all pending updates including those hidden by a filter |
| adAffectAllChapters | 4 | Cancels all pending updates in all child (chapter) recordsets |
| adAffectCurrent | 1 | Cancels only the current record |
| adAffectGroup | 2 | Cancels updates only on records that passed through the filter in effect |
ResyncEnum Constants
| Constant | Value | Description |
|---|---|---|
| adResyncAllValues | 2 | Default, can overwrite all values, and pending updates are cancelled |
| adResyncUnderlyingValues | 1 | Can only overwrite underlying values, and pending updates are not cancelled |
Examples
Code:
objRecordset.Resync adAffectAll
See Also:
