Name
Resync (Recordset Object) —
rsObj.Resync
AffectRecords, ResyncValues
Synopsis
Refreshes the field values for all the records already in your recordset. It does not show you the records added since first opening the database.
Parameters
-
AffectRecords Determines which records in the current Recordset object will be affected by the Resync method call. This parameter is an optional ADO constant that evaluates to one of the following:
-
adAffectCurrent Refreshes only the field values in the current record. This is the default value.
-
adAffectGroup Refreshes only the field values in the records that match the criteria set in the Recordset object's current Filter property.
-
adAffectAll Refreshes the field values in all the records in the current Recordset object.
-
-
ResyncValues Optional. Specifies whether the underlying values should be overwritten:
-
adResyncAllValues Default. Resyncs all data. Any pending updates are overwritten.
-
adResyncUnderlyingValues Does not overwrite any pending updates.
-
Example
<%@ LANGUAGE="VBSCRIPT" %> <% Response.Buffer = True %> <HTML> <HEAD> <TITLE>ADO Examples</TITLE> </HEAD> <BODY> <% ' Include ADOVBS.INC so we can use the ADO constants. %> <!-- #include virtual = "/bc_SSIncludes/adovbs.inc" --> <% ' Instantiate an ADO Connection object. Set objDBConn = Server.CreateObject("ADODB.Connection") ' Construct the connection string for the Connection object. strConn = _ "driver={MyDBType};;uid=sa;pwd=;database=SalesDB" ' Using the connection string, open the connection. ...Get ASP in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
