AddNew

Creates a new record.

BeginInit

Starts the initialization of a recordset that is used on a form or used by another component. The initialization occurs at runtime.

Cancel

Cancels an execution.

CancelBatch

Cancels a batch update.

CancelUpdate

Cancels changes made to a record of a Recordset object.

Clone

Creates a duplicate of an existing Recordset.

Close

Closes a Recordset.

CloseReader

Closes the DataReader associated with the Recordset.

CompareBookmarks(Olevariant,Olevariant)

Compares two bookmarks.

Compute(WideString,WideString)

Computes the given expression on the current rows that pass the filter criteria.

CopyTo(_Array,Integer)

Copies items into an array.

CreateDataReader

Returns a DataTableReader corresponding to the data within this Recordset.

Delete

Deletes a record or a group of records.

DoAddRemoveColumnChangedEvent

Represents method DoAddRemoveColumnChangedEvent.

DoAddRemoveColumnChangingEvent

Represents method DoAddRemoveColumnChangingEvent.

DoAddRemoveEvents

Represents method DoAddRemoveEvents.

DoAddRemoveRowChangedEvent

Represents method DoAddRemoveRowChangedEvent.

DoAddRemoveRowChangingEvent

Represents method DoAddRemoveRowChangingEvent.

DoAddRowUpdatedEvent(TDbDataAdapter)

Represents method DoAddRowUpdatedEvent(TDbDataAdapter).

DoInternalCloseIfReaderIsClosed

Represents method DoInternalCloseIfReaderIsClosed.

DoOptionPropertyChanged(TObject,string)

Represents method DoOptionPropertyChanged(TObject,string).

DoRemoveRowUpdatedEvent(TDbDataAdapter)

Represents method DoRemoveRowUpdatedEvent(TDbDataAdapter).

DoUpdateData

Represents method DoUpdateData.

EndInit

Ends the initialization of a Recordset that is used on a form or used by another component. The initialization occurs at runtime.

Find(Olevariant)

Finds a row in the Recordset by the specified sort key value.

Find(_ObjectArray)

Finds a row in the Recordset by the specified sort key values.

FindRecord(WideString)

Checks if the record exists that match the filter criteria.

FindRows(Olevariant)

Returns an array of DataRowView objects whose columns match the specified sort key value.

FindRows(_ObjectArray)

Returns an array of DataRowView objects whose columns match the specified sort key value.

GetAbsolutePosition

Represents method GetAbsolutePosition.

GetActiveCommand

Represents method GetActiveCommand.

GetActiveConnection

Represents method GetActiveConnection.

GetActiveDataAdapter

Represents method GetActiveDataAdapter.

GetApplyDefaultSort

Represents method GetApplyDefaultSort.

GetBOF

Represents method GetBOF.

GetBookmark

Represents method GetBookmark.

GetCaseSensitive

Represents method GetCaseSensitive.

GetChanges

Gets a copy of the DataTable that contains all changes made to it since it was loaded or AcceptChanges was last called.

GetChanges(TDataRowState_Set)

Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges was called, filtered by DataRowState.

GetColumns

Represents method GetColumns.

GetDataRow

Represents method GetDataRow.

GetDataRowView

Represents method GetDataRowView.

GetDataSet

Represents method GetDataSet.

GetDataTable

Represents method GetDataTable.

GetDataView

Represents method GetDataView.

GetEnforceConstraints

Represents method GetEnforceConstraints.

GetEOF

Represents method GetEOF.

GetErrors

Represents method GetErrors.

GetExtendedProperties

Represents method GetExtendedProperties.

GetFetchingInProgress

Represents method GetFetchingInProgress.

GetFields

Represents method GetFields.

GetFilter

Represents method GetFilter.

GetIndex

Represents method GetIndex.

GetInternalRecordCount

Represents method GetInternalRecordCount.

GetLocale

Represents method GetLocale.

GetNamespace

Represents method GetNamespace.

GetPrefix

Represents method GetPrefix.

GetPrimaryKey

Represents method GetPrimaryKey.

GetReadOnly

Represents method GetReadOnly.

GetRecordCountAsInt32

Represents method GetRecordCountAsInt32.

GetRecordsAffected

Represents method GetRecordsAffected.

GetRemotingFormat

Represents method GetRemotingFormat.

GetRowError

Represents method GetRowError.

GetRows

Represents method GetRows.

GetRowstate

Represents method GetRowstate.

GetRowStateFilter

Represents method GetRowStateFilter.

GetRowVersion

Represents method GetRowVersion.

GetSort

Represents method GetSort.

GetState

Represents method GetState.

GetTableIndex

Represents method GetTableIndex.

GetUpdatesPending

Represents method GetUpdatesPending.

GetXml

Returns the XML representation of the data stored in the Recordset.

GetXmlSchema

Returns the XML Schema for the XML representation of the data stored in the Recordset.

Get_RecordCount

Represents method Get_RecordCount.

Get_SchemaTable

Represents method Get_SchemaTable.

HasChanges

Gets a value indicating whether the Recordset has changes, including new, deleted, or modified rows.

HasChanges(TDataRowState_Set)

Gets a value indicating whether the Recordset has changes, including new, deleted, or modified rows, filtered by DataRowState.

ImportRow(_DataRow)

Copies a DataRow into a Recordset, preserving any property settings, as well as original and current values.

InitializeDataSet

Represents method InitializeDataSet.

IsNull(Integer)

Gets a value that indicates whether the column at the specified index contains a null value.

IsNull(WideString)

Gets a value that indicates whether the named column contains a null value.

Load(_IDataReader)

Fills a Recordset with values from a data source using the supplied IDataReader. If the Recordset already contains rows, the incoming data from the data source is merged with the existing rows.

Load(_IDataReader,TLoadOption)

Fills a Recordset with values from a data source using the supplied IDataReader. If the DataTable already contains rows, the incoming data from the data source is merged with the existing rows according to the value of the loadOption parameter.

LoadAll(Boolean)

Fetch all data from the database.

LoadDataRow(_ObjectArray,Boolean)

Finds and updates a specific row. If no matching row is found, a new row is created using the given values.

LoadDataRow(_ObjectArray,TLoadOption)

Finds and updates a specific row. If no matching row is found, a new row is created using the given values.

Merge(_DataTable)

Merge the specified DataTable with the Recordset.

Merge(_DataTable,Boolean)

Merge the specified DataTable with the Recordset, indicating whether to preserve changes in the Recordset.

Merge(_DataTable,Boolean,TMissingSchemaAction)

Merge the specified DataTable with the Recordset, indicating whether to preserve changes and how to handle missing schema in the Recordset.

Move(Integer)

Moves the record pointer in a Recordset object.

MoveFirst

Moves the record pointer to the first record

MoveLast

Moves the record pointer to the last record.

MoveNext

Moves the record pointer to the next record.

MovePrevious

Moves the record pointer to the previous record.

NextRecordset

Clears the current Recordset object and returns the next Recordset object by looping through a series of commands.

Open

Opens a database element that gives you access to records in a table, the results of a query.

ReadXml(WideString)

Represents method ReadXml(WideString).

ReadXmlSchema(WideString)

Represents method ReadXmlSchema(WideString).

Refresh

Represents method Refresh.

RefreshDataSet

Represents method RefreshDataSet.

Requery

Updates the data in a Recordset by re-executing the query that made the original Recordset.

RevertRecord

Represents method RevertRecord.

Seek(_ObjectArray)

Searches the index of a Recordset to find a record that matches the specified values.

Select

Gets an array of all DataRow objects.

Select(WideString)

Gets an array of all DataRow objects that match the filter criteria.

Select(WideString,WideString)

Gets an array of all DataRow objects that match the filter criteria, in the specified sort order.

Select(WideString,WideString,TDataViewRowState_Set)

Gets an array of all DataRow objects that match the filter in the order of the sort that match the specified state.

SetAbsolutePosition(Integer)

Represents method SetAbsolutePosition(Integer).

SetActiveCommand(TDbCommand)

Represents method SetActiveCommand(TDbCommand).

SetActiveConnection(TDbConnection)

Represents method SetActiveConnection(TDbConnection).

SetAdded

Changes the Rowstate of a recordset DataRow to added.

SetApplyDefaultSort(Boolean)

Represents method SetApplyDefaultSort(Boolean).

SetBookmark(Olevariant)

Represents method SetBookmark(Olevariant).

SetCaseSensitive(Boolean)

Represents method SetCaseSensitive(Boolean).

SetDataSet(_DataSet)

Sets a new DataSet in the Recordset.

SetDataTable(_DataTable)

Sets a new DataTable in the Recordset.

SetDataView(_DataView)

Represents method SetDataView(_DataView).

SetEnforceConstraints(Boolean)

Represents method SetEnforceConstraints(Boolean).

SetFilter(WideString)

Represents method SetFilter(WideString).

SetFilterGroup(TDataViewRowState_Set)

Sets the row state filter used in the RecordSet.

SetIndex(WideString)

Represents method SetIndex(WideString).

SetLocale(_CultureInfo)

Represents method SetLocale(_CultureInfo).

SetModified

Changes the Rowstate of a recordset DataRow to Modified.

SetNamespace(WideString)

Represents method SetNamespace(WideString).

SetPrefix(WideString)

Represents method SetPrefix(WideString).

SetPrimaryKey(_DataColumnArray)

Represents method SetPrimaryKey(_DataColumnArray).

SetReadonly

Allows to control the recordset read-write or read-only mode.

SetRemotingFormat(TSerializationFormat)

Represents method SetRemotingFormat(TSerializationFormat).

SetRowStateFilter(TDataViewRowState_Set)

Represents method SetRowStateFilter(TDataViewRowState_Set).

SetSort(WideString)

Represents method SetSort(WideString).

Set_DataSet(_DataSet)

Represents method Set_DataSet(_DataSet).

Set_DataTable(_DataTable)

Represents method Set_DataTable(_DataTable).

Set_ReadOnly(Boolean)

Represents method Set_ReadOnly(Boolean).

Truncate

Closes the reader associated with the Recordset.

Update(Boolean)

Saves all changes made to a single record  in a Recordset object.

UpdateBatch

Saves all changes in a Recordset to the database. Used when working in batch update mode.

WriteXml(WideString)

Writes the current contents of the Recordset as XML using the specified file.

WriteXml(WideString,Boolean)

Writes the current contents of the Recordset as XML using the specified file. To save the data for the table and all its descendants, set the writeHierarchy parameter to true.

WriteXml(WideString,TXmlWriteMode)

Writes the current data, and optionally the schema, for the Recordset using the specified file and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema.

WriteXml(WideString,TXmlWriteMode,Boolean)

Writes the current data, and optionally the schema, for the Recordset using the specified file and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema. To save the data for the table and all its descendants, set the writeHierarchy parameter to true.

WriteXmlSchema(WideString)

Writes the current data structure of the Recordset as an XML schema to the specified file.

WriteXmlSchema(WideString,Boolean)

Writes the current data structure of the Recordset as an XML schema to the specified file. To save the schema for the table and all its descendants, set the writeHierarchy parameter to true.