When to use the resync method in SQL?
Use the Resync method to resynchronize records in the current Recordset with the underlying database. This is useful if you are using either a static or forward-only cursor, but you want to see any changes in the underlying database. If you set the CursorLocation property to adUseClient, Resync is only available for non-read-only Recordset objects.
What is the default value for the resync method?
An AffectEnum value that determines how many records the Resync method will affect. The default value is adAffectAll. This value is not available with the Resync method of the Fields collection of a Record object. Optional. A ResyncEnum value that specifies whether underlying values are overwritten. The default value is adResyncAllValues.
What happens when resync is called on a field?
Resync will not modify Status values of Field objects unless an error occurs when Resync is called. For example, if the field no longer exists, the provider will return an appropriate Status value for the Field object, such as adFieldDoesNotExist.
Is the resync method available for non-read only objects?
If you set the CursorLocation property to adUseClient, Resync is only available for non-read-only Recordset objects. Unlike the Requery method, the Resync method does not re-execute the Recordset object’s underlying command.
An AffectEnum value that determines how many records the Resync method will affect. The default value is adAffectAll. This value is not available with the Resync method of the Fields collection of a Record object. Optional. A ResyncEnum value that specifies whether underlying values are overwritten. The default value is adResyncAllValues.
Use the Resync method to resynchronize records in the current Recordset with the underlying database. This is useful if you are using either a static or forward-only cursor, but you want to see any changes in the underlying database. If you set the CursorLocation property to adUseClient, Resync is only available for non-read-only Recordset objects.
How to resync a member of a replica set?
This tutorial addresses both resyncing a stale member and creating a new member using seed data from another member, both of which can be used to restore a replica set member. When syncing a member, choose a time when the system has the bandwidth to move a large amount of data.
Resync will not modify Status values of Field objects unless an error occurs when Resync is called. For example, if the field no longer exists, the provider will return an appropriate Status value for the Field object, such as adFieldDoesNotExist.