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. |