CanAppend |
Returns nonzero if new records can be added to the recordset via the AddNew member function. |
CanBookmark |
Returns nonzero if the recordset supports bookmarks. |
CanRestart |
Returns nonzero if Requery can be called to run the recordset’s query again. |
CanScroll |
Returns nonzero if you can scroll through the records. |
CanTransact |
Returns nonzero if the data source supports transactions. |
CanUpdate |
Returns nonzero if the recordset can be updated (you can add, update, or delete records). |
GetODBCFieldCount |
Returns the number of fields in the recordset. |
GetRecordCount |
Returns the number of records in the recordset. |
GetStatus |
Gets the status of the recordset: the index of the current record and whether a final count of the records has been obtained. |
GetTableName |
Gets the name of the table on which the recordset is based. |
GetSQL |
Gets the SQL string used to select records for the recordset. |
IsOpen |
Returns nonzero if Open has been called previously. |
IsBOF |
Returns nonzero if the recordset has been positioned before the first record. There is no current record. |
IsEOF |
Returns nonzero if the recordset has been positioned after the last record. There is no current record. |
IsDeleted |
Returns nonzero if the recordset is positioned on a deleted record. |
GetBookmark |
Assigns the bookmark value of a record to the parameter object. |
Move |
Positions the recordset to a specified number of records from the current record in either direction. |
MoveFirst |
Positions the current record on the first record in the recordset. Test for IsBOF first. |
MoveLast |
Positions the current record on the last record or on the last rowset. Test for IsEOF first. |
MoveNext |
Positions the current record on the next record or on the next rowset. Test for IsEOF first. |
MovePrev |
Positions the current record on the previous record or on the previous rowset. Test for IsBOF first. |
SetAbsolutePosition |
Positions the recordset on the record corresponding to the specified record number. |
SetBookmark |
Positions the recordset on the record specified by the bookmark. |
Cancel |
Cancels an asynchronous operation or a process from a second thread. |
FlushResultSet |
Returns nonzero if there is another result set to be retrieved, when using a predefined query. |
GetFieldValue |
Returns the value of a field in a recordset. |
GetODBCFieldInfo |
Returns specific kinds of information about the fields in a recordset. |
GetRowsetSize |
Returns the number of records you wish to retrieve during a single fetch. |
GetRowsFetched |
Returns the actual number of rows retrieved during a fetch. |
GetRowStatus |
Returns the status of the row after a fetch. |
IsFieldDirty |
Returns nonzero if the specified field in the current record has been changed. |
IsFieldNull |
Returns nonzero if the specified field in the current record is Null (has no value). |
IsFieldNullable |
Returns nonzero if the specified field in the current record can be set to Null (having no value). |
RefreshRowset |
Refreshes the data and status of the specified row(s). |
Requery |
Runs the recordset’s query again to refresh the selected records. |
SetFieldDirty |
Marks the specified field in the current record as changed. |
SetFieldNull |
Sets the value of the specified field in the current record to Null (having no value). |
SetLockingMode |
Sets the locking mode to “optimistic” locking (the default) or “pessimistic” locking. Determines how records are locked for updates. |
SetParamNull |
Sets the specified parameter to Null (having no value). |
SetRowsetCursorPosition |
Positions the cursor on the specified row within the rowset. |