The GROUP BY Support property indicates the relationship between the columns in a GROUP BY clause and the nonaggregated columns in a SELECT statement.
object.Properties("GROUP BY Support")
object
Expression that evaluates to an object in the Applies To list.
One of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_GB_EQUALS_SELECT | The GROUP BY clause must contain all nonaggregated columns in the select list. It cannot contain any other columns (for example, SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT). |
| DBPROPVAL_GB_COLLATE | A COLLATE clause can be specified at the end of each grouping column. |
| DBPROPVAL_GB_CONTAINS_SELECT | The GROUP BY clause must contain all nonaggregated columns in the select list. It can contain columns that are not in the select list (for example, SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT, AGE). |
| DBPROPVAL_GB_NO_RELATION | The columns in the GROUP BY clause and the SELECT statement are not related (for example, SELECT DEPT, SALARY FROM EMPLOYEE GROUP BY DEPT, AGE). |
adInteger
Read-only
DBPROP_GROUPBY