| title | Changes You Might Make to the Default Code (MFC Data Access) | Microsoft Docs | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ms.custom | ||||||||||||||
| ms.date | 11/04/2016 | |||||||||||||
| ms.reviewer | ||||||||||||||
| ms.suite | ||||||||||||||
| ms.technology |
|
|||||||||||||
| ms.tgt_pltfrm | ||||||||||||||
| ms.topic | article | |||||||||||||
| dev_langs |
|
|||||||||||||
| helpviewer_keywords |
|
|||||||||||||
| ms.assetid | 9992ed37-a6bf-45a5-a572-5c14e42b6628 | |||||||||||||
| caps.latest.revision | 8 | |||||||||||||
| author | mikeblome | |||||||||||||
| ms.author | mblome | |||||||||||||
| manager | ghogen | |||||||||||||
| translation.priority.ht |
|
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 its Open member 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).