The following table shows the methods the Recordset object supports.
Method |
Description |
| AddNew | Inserts a new row into the recordset. |
| CancelUpdate | Cancels changes held in memory. |
| Clone | Duplicates a recordset. |
| Close | Closes a recordset. |
| Delete | Deletes a row from the recordset. |
| GetRows | Returns data stored in the recordset. |
| Move | Changes the pointer to the active row in the recordset. |
| MoveFirst | Makes the first row active. |
| MoveLast | Makes the last row active. |
| MoveNext | Moves the active row pointer to the next row. |
| MovePrevious | Moves the active row pointer to the previous row. |
| Open | Defines and opens recordsets; runs SQL commands. |
| Supports | Determines if the recordset supports certain features. |
| Update | Commits changes held in memory and updates the actual table. |
Because ADOCE databases are intended to be accessed by a single user, there is no batch update mode. ADOCE does not support the following methods:
The following table shows the properties the Recordset object supports.
Property |
Description |
| AbsolutePage | Specifies which page to move for a new current record. |
| AbsolutePosition | Specifies the ordinal position of a Recordset object’s current record. |
| ActiveConnection | Sets the current database connection. Always a zero-length string (""). |
| BOF | Indicates whether the current record position is before the first record in a Recordset object. |
| Bookmark | Specifies a bookmark that uniquely identifies a record in a Recordset object. |
| CacheSize | Specifies the number of records from a Recordset object that are cached locally in memory. |
| CursorType | Indicates the type of cursor used in a Recordset object. |
| EditMode | Indicates the editing status of the current record. |
| EOF | Indicates that the current record position is after the last record in a Recordset object. |
| LockType | Indicates the type of locks placed on records during editing. |
| PageCount | Indicates how many pages of data the Recordset object contains. |
| PageSize | Indicates how many records constitute one page in the Recordset. |
| RecordCount | Returns a Long value that indicates the current number of records in a Recordset object. |
| Source | Indicates the source for the data in a Recordset object — SQL statement or table name. |
A recordset is a virtual database table whose fields and rows correspond to a subset of the fields and rows in an actual database table on the H/PC. When you make additions, deletions, or changes to the information in a recordset row, you can pass those changes to the corresponding parts of the table. When you change data in the recordset, the recordset stores the changes in memory, enabling you to cancel them before the underlying database is updated. ADOCE does not support batch updates. Only one row at a time can have data that is changed but not committed to the underlying database.
When you change the structure of the recordset table, the changes to the underlying database table are immediate.