Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Resync - method of object AdoRecordset

Description:
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.
Syntax:
Resync([nAffectRecords], [nResyncValues])
Calling:
oRs.Resync nAffectRecords, nResyncValues
Parameters:
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 database 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.
Note:
Compared to the Requery method, the SQL query is not re-executed.
See also:
Example:
Re-reading of existing data of the AdoRecordset object, previously created and stored in the PmaAdo object ("/TestAdoDb") with defined identifier ("table1").
JavaScriptVBScriptSelect and copy to clipboard

var oDb = pMe.Pm("/TestAdoDb");
var oRs = oDb.RsGet("table1");
if (oRs)
oRs.Resync();

History:
Pm8.01.00: Created
PROMOTIC 9.0.3 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice