Subquery Support Property
The Subquery Support property returns a bitmask specifying the predicates in text commands that support subqueries.
Applies To
| Connection Object |
Syntax
object.Properties("Subquery Support")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
A combination of zero or more of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_SQ_CORRELATEDSUBQUERIES | All predicates that support subqueries support correlated subqueries. |
| DBPROPVAL_SQ_COMPARISON | Comparison operators are supported. |
| DBPROPVAL_SQ_EXISTS | The EXISTS clause is supported. |
| DBPROPVAL_SQ_IN | The IN clause is supported. |
| DBPROPVAL_SQ_QUANTIFIED | Quantified predicates are supported. |
| DBPROPVAL_SQ_TABLE | Subqueries are supported in place of tables (for example, in the FROM clause of an SQL statement). |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_SUBQUERIES