ISQLComponents.GroupBy

Syntax

GroupBy: String;

Description

The GroupBy property determines a part of query where an expression for results grouping is specified.

Comments

If the property value was obtained in a separate variable and the expression is modified in the variable, then it is required to rewrite property value to apply changes:

Public Class SQLCallback: Object, ISQLCallback
    Sub BeforeConstruction(Components: ISQLComponents);
    Var
        GroupBy: String;
    Begin
        GroupBy := Components.GroupBy;
        //...
        //Modification of GroupBy
        //...
        Components.GroupBy := GroupBy;
    End Sub BeforeConstruction;

    Sub AfterConstruction(Var SQL: String);
    Begin
    End Sub AfterConstruction;
End Class SQLCallback;

Example

The example of use is given in description of the ISQLCallback.BeforeConstruction method.