| title | Changes You Might Make to the Default Code (MFC Data Access) | |
|---|---|---|
| ms.date | 11/04/2016 | |
| helpviewer_keywords |
|
|
| ms.assetid | 9992ed37-a6bf-45a5-a572-5c14e42b6628 |
The MFC Application Wizard writes a recordset class for you that selects all records in a single table. You will often want to modify that behavior in one or more of the following ways:
-
Set a filter or a sort order for the recordset. Do this in
OnInitialUpdateafter the recordset object is constructed but before itsOpenmember function is called. For more information, see Recordset: Filtering Records (ODBC) and Recordset: Sorting Records (ODBC). -
Parameterize the recordset. Specify the actual run-time parameter value after the filter. For more information, see Recordset: Parameterizing a Recordset (ODBC)
-
Pass a customized SQL string to the Open member function. For a discussion of what you can accomplish with this technique , see SQL: Customizing Your Recordset's SQL Statement (ODBC).