HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...

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 Exam

ADO Certificate

ADO Value Property

Complete Field Object Reference

The Value property sets or returns the value of a Parameter, Field, or Property object.

Object	Description of the Value Property
Parameter	The Value property sets or returns a variant that indicates the value of the Parameter object Note: The Recordset should be closed before you try to read the Value property. ADO can only read the Value property once from the provider
Field	The Value property sets or returns a variant that indicates the current value of the Field object Note: For a new Field object that are added to the Fields collection of a Record, you must first set the Value property and perform an update before you can set any other property
Property	The Value property sets or returns a variant that indicates the current value of the Property object Note: You cannot set the Value for properties that are read-only

Object

Description of the Value Property

Parameter

The Value property sets or returns a variant that indicates the value of the Parameter object

Note: The Recordset should be closed before you try to read the Value property. ADO can only read the Value property once from the provider

Field

The Value property sets or returns a variant that indicates the current value of the Field object

Note: For a new Field object that are added to the Fields collection of a Record, you must first set the Value property and perform an update before you can set any other property

Property

The Value property sets or returns a variant that indicates the current value of the Property object

Note: You cannot set the Value for properties that are read-only

Syntax

objectname.Value

Example - For a Field object

Example - For a Parameter object

<%
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("ADODB.Parameter")

para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname

comm.Parameters.Append para
%>

Example - For a Property object

<%
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 "Select * from orders", conn

set prop=Server.CreateObject("ADODB.Property")

'Display the property attributes of the Orders Table
for each prop in rs.Properties
  response.write("Attr:" & prop.Attributes & "<br />")
  response.write("Name:" & prop.Name & "<br />")
  response.write("Value:" & prop.Value & "<br />")
next

rs.close
conn.close
set rs=nothing
set conn=nothing
%>