Previous PageNext Page

9.5.12 Value Property

Indicates the value assigned to a Field object.
 

Return Values

Sets or returns a Variant value. Default value depends on the Type property.
 

Remarks

Use the Value property to set or return data from Field objects. ADO allows setting and returning long binary data with the Value property.
 

Example

This Visual Basic example demonstrates the Value property with Field and Property objects by displaying field and property values for the Employees table.
 

Public Sub ValueX()

Dim rstEmployees As ADODB.Recordset

Dim fldLoop As ADODB.Field

Dim prpLoop As ADODB.Property

Dim strCnn As String

' Open recordset with data from Employee table.

strCnn = "driver={SQL Server};server=srv;" & _

"uid=sa;pwd=;database=pubs"

Set rstEmployees = New ADODB.Recordset

rstEmployees.Open "employee", strCnn, , , adCmdTable

Debug.Print "Field values in rstEmployees"

' Enumerate the Fields collection of the Employees

' table.

For Each fldLoop In rstEmployees.Fields

` Because Value is the default property of a

` Field object, the use of the actual keyword

` here is optional.

Debug.Print " " & fldLoop.Name & " = " &

fldLoop.Value

Next fldLoop

Debug.Print "Property values in rstEmployees"

' Enumerate the Properties collection of the

' Recordset object.

For Each prpLoop In rstEmployees.Properties

' Because Value is the default property of a

' Property object, the use of the actual keyword

' here is optional.

Debug.Print " " & prpLoop.Name & " = " &

prpLoop.Value

Next prpLoop

rstEmployees.Close

End Sub


Copyright © 2000 Chili!Soft

Previous PageTop Of PageNext Page