Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











PROPERTY: Field::UnderlyingValue
Variant = fieldobject.UnderlyingValue
 
The UnderlyingValue property returns a variant that is the current value of the Field object as stored in the cursor. It is referred to as the underlying value, because the value you are viewing may not necessarily show changes made by other users and may not be the latest value. The value returned by the UnderlyingValue property will reflect all of the changes made in the current record for the specified Field. This can be very useful for resolving conflicts between changes made by you and other users.
 
You can also use the Resync property of the Recordset object to get the latest values for all of the Field objects in the Fields Collection.
 
If you need the original value, you can obtain it by using the OriginalValue property.
 
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-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information