PROPERTY: Field::OriginalValue

variant = fieldobject.OriginalValue
 
The OriginalValue property returns a variant that is the value of the Field object as it existed in the record after the last Update or UpdateBatch method call, but before any current changes. This is possible because additions and deletions to the Field are cached until an update is performed. This is a quick way to get back to the original Field value.
 
Calling either the CancelBatch or CancelUpdate methods of the Recordset object will have the same effect as calling the OriginalValue property. The provider will return the value that the Field had after the last Update or UpdateBatch method call, but prior to any current changes.
 
Code (VBScript):
For Each objField In rsData.Fields
   Response.Write objField.OriginalValue & VBCRLF
   Response.Write objField.UnderlyingValue & VBCRLF
   Response.Write objField.Value & VBCRLF
Next

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information