MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix C: OLE DB Properties

DBPROP_FILTERCOMPAREOPS

Property group: View

Property set: DBPROPSET_VIEW

Column? Y

Type: VT_I4

Typical R/W: R

Description: Filter Operations

A bitmask describing the comparison operations supported by IViewFilter for a particular column. If no column is specified, the full set of comparison operators that may be supported is as follows:

• DBPROPVAL_CO_EQUALITY — Provider supports the following comparison operators:
  • DBCOMPAREOPS_LT
    
    
  • DBCOMPAREOPS_LE
    
    
  • DBCOMPAREOPS_EQ
    
    
  • DBCOMPAREOPS_GE
    
    
  • DBCOMPAREOPS_GT
    
    
  • DBCOMPAREOPS_NE
• DBPROPVAL_CO_STRING — Provider supports the comparison operator DBCOMPAREOPS_BEGINSWITH.
  
  
• DBPROPVAL_CO_CONTAINS—Provider supports the following comparison operators:
  • DBCOMPAREOPS_CONTAINS
    
    
  • DBCOMPAREOPS_NOTCONTAINS
• DBPROPVAL_CO_BEGINSWITH—Provider supports the following comparison operators:
  • DBCOMPAREOPS_BEGINSWITH
    
    
  • DBCOMPAREOPS_NOTBEGINSWITH
• DBPROPVAL_CO_CASESENSITIVE — Provider supports the DBCOMPAREOPS_CASESENSITIVE modifier.
  
  
• DBPROPVAL_CO_CASEINSENSITIVE — Provider supports the DBCOMPAREOPS_CASEINSENSITIVE modifier.

Note   Providers may support one or the other or both of DBPROPVAL_CO_CASESENSITIVE and DBPROPVAL_CO_CASEINSENSITIVE.