1. Home

ADO OriginalValue and UnderlyingValue Properties

The OriginalValue property returns a variant that contains the field value asit existed right after the last Update or UpdateBatch method call."

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

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US