Description
Represents the entire set of records resulting from an executed command. At any given time, the Recordset object refers to a single record within the record set as the current record.
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