Calculating Operations

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.