ISQLComponents.OrderBy

Syntax

OrderBy: String;

Description

The OrderBy property determines a part of query where the expression for results sorting 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
        OrderBy: String;
    Begin
        OrderBy := Components.OrderBy;
        //...
        //Modification of OrderBy
        //...
        Components.OrderBy := OrderBy;
    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.