CDaoRecordset::m_strFilter

  • 项目

Remarks

Contains a string that is used to construct the WHERE clause of an SQL statement. It does not include the reserved word WHERE to filter the recordset. The use of this data member is not applicable to table-type recordsets. The use of m_strFilter has no effect when opening a recordset using a CDaoQueryDef pointer.

Use the U.S. date format (month-day-year) when you filter fields containing dates, even if you are not using the U.S. version of the Microsoft Jet database engine; otherwise, the data may not be filtered as you expect.

For more information about selecting records, see the article in Visual C++ Programmer's Guide. For related information, see the topic "Filter Property" in DAO Help.

CDaoRecordset Overview |  Class Members |  Hierarchy Chart

See Also   CDaoRecordset::m_strSort