DevGuru ADO Recordset::Resync Method

Quick References

Features

Partners

METHOD: Recordset::Resync

recordsetobject.Resync AffectRecords, ResyncValues

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

The optional ResyncValues parameter is one of the ResyncEnum constants that determines which values can be overwritten. The default is adResyncAllValues.

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

Code (VBScript):
objRecordset.Resync adAffectAll