recordset-declaring-a-class-for-a-table-odbc.md

description	title	ms.date	helpviewer_keywords	ms.assetid
Learn more about: Recordset: Declaring a Class for a Table (ODBC)	Recordset: Declaring a Class for a Table (ODBC)	05/09/2019	ODBC recordsets, declaring class for tables recordsets, declaring classes for tables	3fe286c2-3f3d-493d-9d8c-762310939d08

Recordset: Declaring a Class for a Table (ODBC)

Note

The MFC ODBC Consumer wizard is not available in Visual Studio 2019 and later. You can still create a consumer manually.

This topic applies to the MFC ODBC classes.

The most common recordset class opens a single table. To declare a recordset class for a single table, use the MFC ODBC Consumer Wizard from Add Class and choose each column you want by naming a corresponding recordset field data member.

Other uses for recordsets include:

• Joining two or more tables.

• Containing the results of a predefined query.

See also

Recordset (ODBC)
Recordset: Creating and Closing Recordsets (ODBC)
Recordset: Declaring a Class for a Predefined Query (ODBC)
Recordset: Performing a Join (ODBC)