The Subquery Support property returns a bitmask specifying the predicates in text commands that support subqueries.
object.Properties("Subquery Support")
object
Expression that evaluates to an object in the Applies To list.
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). |
adInteger
Read-only
DBPROP_SUBQUERIES