Compartir a través de


DBPROP_GROUPBY

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: GROUP BY Support

Indicates the relationship between the columns in a GROUP BY clause and the nonaggregated columns in the select list. One of the following:

  • 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 list are not related. The meaning of nongrouped, nonaggregated columns in the select list is data source object?dependent ? for example, SELECT DEPT, SALARY FROM EMPLOYEE GROUP BY DEPT, AGE.

See Also

Reference

Properties (Alphabetical)