Recordset Object
Description
Represents the entire set of records resulting from an executed command. At any given time, a Recordset object refers to a single record within the record set as the current record.
Remarks

A Recordset object is returned by Command.Execute.

The Position indicates the record to which the Recordset cursor points, the currently active record. The first record is numbered 0. The FieldValue refers to the values in the currently active record.

If there are no records in the Recordset, BOR and EOR BOR and EOR are true and the Position is 0.

Public Methods
Public Method CloneCreates a duplicate of this Recordset object.
Public Method FirstMoves to the first record and makes it the current record.
Public Method LastMoves to the last record and makes it the current record.
Public Method NextMoves to the next record and makes it the current record.
Public Method PrevMoves to the previous record and makes it the current record.
Public Method RefreshRefreshes the Recordset, overwriting values in memory.
Public Properties
Public Property BORChecks if the record cursor is on the first record.
Public Property CacheSizeThe number of records in the recordset that are cached locally in memory.
Public Property ColCountGets the number of columns in the current Recordset object.
Public Property ColIndexGets the index (zero-based) of a Recordset column specified by column name.
Public Property ColNameThe name of the Recordset column specified by Index (zero-based).
Public Property ColSizeThe physical size as defined in the database of the fields in the column specified by Index (zero-based).
Public Property ColTypeThe data type of column.
Public Property EORChecks if the record cursor is after the last record.
Public Property FieldValueThe value for the specified field.
Public Property PositionThe current record position (0-based).
Public Property RecordCountThe number of records in the Recordset.
See Also