Record Object

A Record object represents one row of data, and has some conceptual similarities with a one-row Recordset. An application can retrieve Record objects directly from the provider instead of a one-row Recordset, for example when an SQL query that selects only one row (singleton select) is executed. It is much more efficient for an application to use a Record object than a Recordset object if only one row is to be retrieved from a query.

A Record object also can be obtained directly from a Recordset object.