Constant | Calculating operation |
gdbCalcNone | A field is not the calculated one. |
gdbCalcCount | Record count in a group. |
gdbCalcEmptyCount | Record count in a group of records containing an empty value in a field. The operation is impossible for queries of external databases. |
gdbCalcNotEmptyCount | Record count in a group of records containing a non-empty value in a field. The operation is impossible for queries of external databases. |
gdbCalcTrueCount | Record count in a group of records containing the true value in a field. This operation is possible for fields of the gdbFieldTypeBoolean type only. The operation is impossible for queries of external databases. |
gdbCalcFalseCount | Record count in a group of records containing the false value in a field. This operation is possible for fields of the gdbFieldTypeBoolean type only. The operation is impossible for queries of external databases. |
gdbCalcSum | Calculates a sum of field values in a group of records. This operation is possible for numeric fields only (the Field::IsNumeric property returns True). |
gdbCalcAvg | Calculates an average of field values in a group of records. This operation is possible for numeric fields only (the Field::IsNumeric property returns True). |
gdbCalcMax | Defines the maximum of a field value in a group of records. This operation is only possible for GDB query fields of gdbFieldTypeInteger, gdbFieldTypeDouble, gdbFieldTypeDate, gdbFieldTypeTime, and gdbFieldTypeTimestamp types. |
gdbCalcMin | Defines the minimum of a field value in a group of records. This operation is only possible for GDB query fields of gdbFieldTypeInteger, gdbFieldTypeDouble, gdbFieldTypeDate, gdbFieldTypeTime, and gdbFieldTypeTimestamp types. |