Resync - method of object AdoRecordset

The method refreshes the data in the AdoRecordset object. Only the records currently existing in the AdoRecordset object are synchronized. Eventual new records will not be seen in the database.
Resync([nAffectRecords As Long], [nResyncValues As Long])
oRs.Resync nAffectRecords, nResyncValues
nAffectRecords[optional] (Long) The ADO AffectEnum type value defines which records will be restored.
1 - (adAffectCurrent) Current record.
2 - (adAffectGroup) The records that comply with the filtering criteria (Recordset.Filter property).
3 (default) - (adAffectAll) All records.
nResyncValues[optional] (Long) The ADO ResyncEnum value type that specifies whether the values in the datbase are to be overwritten.
1 - (adResyncUnderlyingValues) Does not overwrite data, and pending changes are not cancelled.
2 (default) - (adResyncAllValues) Overwrites the data and pending changes are cancelled.
Compared to the Requery method, the SQL query is not re-executed.
See also:
Re-reading of existing data in the AdoRecordset object, previously created and stored in the PmAdo object ("/TestAdoDb") with defined identifier ("table1").
Dim oDb, oRs
Set oDb = pMe.Pm("/TestAdoDb")
Set oRs = oDb.RsGet("table1")
End If
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice