Export (0) Print
Expand All
Expand Minimize

OriginalValue Property (ADO)

Indicates the value of a Field that existed in the record before any changes were made.

Returns a Variant value that represents the value of a field prior to any change.

Use the OriginalValue property to return the original field value for a field from the current record.

In immediate update mode (in which the provider writes changes to the underlying data source after you call the Update method), the OriginalValue property returns the field value that existed prior to any changes (that is, since the last Update method call). This is the same value that the CancelUpdate method uses to replace the Value property.

In batch update mode (in which the provider caches multiple changes and writes them to the underlying data source only when you call the UpdateBatch method), the OriginalValue property returns the field value that existed prior to any changes (that is, since the last UpdateBatch method call). This is the same value that the CancelBatch method uses to replace the Value property. When you use this property with the UnderlyingValue property, you can resolve conflicts that arise from batch updates.

For Record objects, the OriginalValue property will be empty for fields added before Update is called.

Show:
© 2014 Microsoft