ADCPROP_UPDATERESYNC_ENUM

Microsoft ActiveX Data Objects (ADO)

ADCPROP_UPDATERESYNC_ENUM

   

Specifies whether the UpdateBatch method is followed by an implicit Resync method operation and if so, the scope of that operation.

Constant Value Description
adResyncAll 15 Invokes Resync for each row with pending changes.
adResyncAutoIncrement 1 Default. Attempts to retrieve the new identity value for columns that are automatically incremented or generated by the data source, such as Microsoft Jet AutoNumber fields or Microsoft SQL Server Identity columns.
adResyncConflicts 2 Invokes Resync for all rows in which the update or delete operation failed because of a concurrency conflict.
adResyncInserts 8 Invokes Resync for all successfully inserted rows. However, primary key column values are not resynchronized. Instead, contents of newly inserted rows are resynchronized based on the existing primary key value. If the primary key value has changed, Resync won't retrieve the contents of the intended row. For automatically incrementing primary key values, first call UpdateBatch with adResyncAutoIncrement to retrieve the data source-generated primary key value.
adResyncNone 0 Does not invoke Resync.
adResyncUpdates 4 Invokes Resync for all successfully updated rows.