ADO Hersinkroniseer metode
❮ Voltooi rekordstel-objekverwysing
Die Hersinkroniseer-metode verfris die data in 'n rekordstel.
Wenk: Gebruik hierdie metode om die rekordstel met die databasis te hersinkroniseer. As jy veranderinge in die databasis wil sien en jy gebruik 'n statiese of slegs vorentoe-rekordstel, is hierdie metode nuttig.
Let wel: Hierdie metode voer nie die rekordstel weer uit nie, so nuwe rekords in die databasis sal NIE sigbaar wees nie.
Sintaksis
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 |
AffekteerEnum-waardes
| 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 |
HersinkroniseerEnum-waardes
| 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 |
❮ Voltooi rekordstel-objekverwysing