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
 Clone | Creates a duplicate of this Recordset object. |
| First | Moves to the first record and makes it the current record. |
| Last | Moves to the last record and makes it the current record. |
| Next | Moves to the next record and makes it the current record. |
| Prev | Moves to the previous record and makes it the current record. |
| Refresh | Refreshes the Recordset, overwriting values in memory. |
Public Properties
 BOR | Checks if the record cursor is on the first record. |
| CacheSize | The number of records in the recordset that are cached locally in memory. |
| ColCount | Gets the number of columns in the current Recordset object. |
| ColIndex | Gets the index (zero-based) of a Recordset column specified by column name. |
| ColName | The name of the Recordset column specified by Index (zero-based). |
| ColSize | The physical size as defined in the database of the fields in the column specified by Index (zero-based). |
| ColType | The data type of column. |
| EOR | Checks if the record cursor is after the last record. |
| FieldValue | The value for the specified field. |
| Position | The current record position (0-based). |
| RecordCount | The number of records in the Recordset. |
See Also