X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO Resync Method


Recordset Object Reference 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


Recordset Object Reference Complete Recordset Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook