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

DBPROP_SUBQUERIES

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: Subquery Support

A bitmask specifying the predicates in text commands that support subqueries. A combination of zero or more of the following:

• DBPROPVAL_SQ_CORRELATEDSUBQUERIES
  
  
• DBPROPVAL_SQ_COMPARISON
  
  
• DBPROPVAL_SQ_EXISTS
  
  
• DBPROPVAL_SQ_IN
  
  
• DBPROPVAL_SQ_QUANTIFIED
  
  
• DBPROPVAL_SQ_TABLE

The DBPROPVAL_SQ_CORRELATEDSUBQUERIES bit indicates that all predicates that support subqueries support correlated subqueries.

The DBPROPVAL_SQ_TABLE bit indicates that subqueries are supported in place of tables (for example, in the FROM clause of an SQL statement).