OLE DB Programmer's Reference | |
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_SELECTThe GROUP BY clause must contain all nonaggregated columns in the select list. It cannot contain any other columnsfor example, SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT.
- DBPROPVAL_GB_COLLATEA COLLATE clause can be specified at the end of each grouping column.
- DBPROPVAL_GB_CONTAINS_SELECTThe GROUP BY clause must contain all nonaggregated columns in the select list. It can contain columns that are not in the select listfor example, SELECT DEPT, MAX(SALARY) FROM EMPLOYEE GROUP BY DEPT, AGE.
- DBPROPVAL_GB_NO_RELATIONThe 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 objectdependentfor example, SELECT DEPT, SALARY FROM EMPLOYEE GROUP BY DEPT, AGE.
1998-2001 Microsoft Corporation. All rights reserved.