Methods

The following table shows the methods that 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 a recordset.
GetRows Returns data stored in a recordset.
Move Moves the position of the current record in a 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 a recordset supports certain features.
Update Commits changes held in a recordset to the database on the device.