Value Property

Applies To:

Recordset object

Description:

The value stored in a given field of the current record.

Syntax:

VARIANT Recordset.Value ( VARIANT index )
VARIANT Recordset ( VARIANT index )

index
   may be an integer, string, or a Field object. The string is the name of the Field.

Remarks:

Value is the default member of Recordset; thus you may use the index as an argument without explicitly including the Value property.

Example:

This Visual Basic example shows the Value property returning data from the second field of a current record in the RecSet Recordset.

Dim DataObject As Object 'Object of proper type
Dim Datum As Variant      'Non-object data
Dim RecSet As Object      'Recordset object

'In case value is a structure, the object must be set
If (FinderDoc.Fields(2).Type = kCFStructure) Then
    Set DataObject = RecSet.Value(2) 'Get data
Else
    Datum = RecSet.Value(2) 'otherwise value is assigned
End If

'Code to create DataObject has been omitted.

See Also:



2005 CambridgeSoft Corporation. All Rights Reserved. Privacy Statement
Tel  800 315-7300 / 617 588-9300     Fax  617 588-9390     Email   info@cambridgesoft.com
CambridgeSoft Corporation, 100 CambridgePark Drive, Cambridge, MA 02140 USA