ADO OriginalValue and UnderlyingValue Properties

## ADO Tutorial

ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

## ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes
ADO Summary

## ADO Examples

ADO Examples

# 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

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE