Index Next

Using a Record Set

The Fields of a Recordset 

The Fields Collection

• The Open() method of a Recordset object, is used to select the records.
• The records are primarily identified by the columns that organize them.,
• each Recordset object of the libraries we have so far is equipped with a property named Fields, which is a collection of the columns of the record set.
• To identify the name of a column, the Field object is equipped with a property named Name.

Private Sub cmdVideoData_Click()

    Dim rstVideos As ADODB.Recordset

    Dim fldEach As ADODB.Field

    Set rstVideos = New ADODB.Recordset

    rstVideos.Open "Videos", _

                   Application.CodeProject.Connection, _

                   adOpenStatic, adLockOptimistic, adCmdTable

    For Each fldEach In rstVideos.Fields

        MsgBox fldEach.Name

    Next

    rstVideos.Close

    Set rstVideos = Nothing

End Sub

Don't Move Beyond the Extremes

Some, if not most operations require that you remain within the range of values of the record set. If you move below the first record record, you (actually the user) may receive an error. In the same way, if you move beyond the last record, you would receive an error. To assist you with checking whether you are in the first record, the Recordset object provides the BOF() method. This method returns a Boolean value as follows:

• If it returns TRUE, then you are currently positioned before the first record
• If it returns FALSE, then you are at or above the first record

On the other hand, if you want to check whether you are at the highest position of the records, you can call the EOF() method of the Recordset object. It also returns a Boolean value as follows:

• If it returns TRUE, then you are currently positioned after the last record
• If it returns FALSE, then you are at or below the last record