Changes You Might Make to the Default Code

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 OnInitialUpdate after 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).

See Also

Concepts