ADO OriginalValue and UnderlyingValue Properties
 Complete Field Object Reference
The OriginalValue property returns a variant that contains the field value as
it existed right after the last Update or UpdateBatch method call.
The UnderlyingValue property returns a variant that contains the
current value of a field. This value does not necessarily show changes made by other users and may not be the latest value.
Tip: Use the Resync property of the Recordset object to get the latest values for all of the Field objects in the Fields Collection.
Tip: These properties can be used together to prevent update conflicts.
Syntax
objField.OriginalValue
objField.UnderlyingValue
|
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open "customers", conn
set objfield=rs.fields("companyname")
'Some code..................
'Check for changes
rs.movefirst
while rs.eof=false
if objfield.OriginalValue<>objfield.UnderlyingValue then
response.write("Data has changed!<br />")
response.write("Original value: ")
response.write(objfield.OriginalValue & "<br />")
response.write("Current value: ")
response.write(objfield.UnderlyingValue & "<br />")
end if
rs.movenext
next
'More code...................
rs.Close
conn.close
%>
|
Complete Field Object Reference
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a free 30-day trial today!
Click to see a demo!
Learn what’s new in v2008
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|
HOME
Printer friendly page
