TDABaseOrderByCollection

Overview

TDABaseOrderByCollection is a part of TDAQueryBuilder that specifies how to fields should be sorted. Also it contains method that generate ORDER BY statement

You shoudn't use this class directly because it is used in TDAQueryBuilder.GenerateSelectSQL:

procedure TForm1.Button1Click(Sender: TObject);
var
  qb: TDASQL92QueryBuilder;
begin
  qb := TDASQL92QueryBuilder.Create;
  try
    qb.MainTable.MasterTable := 'MERCHANDISE';
    qb.AddSelect('MERCHANDISE','DESCRIPTION');
    qb.AddOrderBy('MERCHANDISE','DESCRIPTION',True);
    Memo1.Lines.Text:= qb.GenerateSelectSQL;
  finally
    qb.free;
  end;
end;

Location

Unit: uDASimpleQueryBuilder.pas
Ancestry: TCollection | TDABaseOrderByCollection

constructor Create (TDASimpleQueryBuilder) reintroduce overload

Creates a new instance and allows to use existing aQueryBuilder.FieldGenerator

constructor Create(aQueryBuilder: TDASimpleQueryBuilder)

Parameters:

aQueryBuilder: query builder

Assign override

Copies data from a given source.

procedure Assign(Source: TPersistent)

Parameters:

Source: Instance whose properties will be copied

AssignOrderByCollection virtual

Copies the contents of another collection to the object where the method is executed.

procedure AssignOrderByCollection(Source: TDABaseOrderByCollection)

Parameters:

Source: Instance whose properties will be copied

FieldGenerator

Referense to TDABaseFieldGenerator that contains rules for generating field name

property FieldGenerator: TDABaseFieldGenerator read write

GenerateOrderByStatement

Generates ORDER BY statement.

function GenerateOrderByStatement: string

Items

This property allows the collection content to be accessed by index.

property Items[Index: Integer]: TDAOrderByItem read write

OwnFieldGenerator

Uses own generator or not

property OwnFieldGenerator: Boolean read write

FieldGenerator

Referense to TDABaseFieldGenerator that contains rules for generating field name

property FieldGenerator: TDABaseFieldGenerator read write

Items

This property allows the collection content to be accessed by index.

property Items[Index: Integer]: TDAOrderByItem read write

OwnFieldGenerator

Uses own generator or not

property OwnFieldGenerator: Boolean read write

constructor Create (TDASimpleQueryBuilder) reintroduce overload

Creates a new instance and allows to use existing aQueryBuilder.FieldGenerator

constructor Create(aQueryBuilder: TDASimpleQueryBuilder)

Parameters:

aQueryBuilder: query builder

Assign override

Copies data from a given source.

procedure Assign(Source: TPersistent)

Parameters:

Source: Instance whose properties will be copied

AssignOrderByCollection virtual

Copies the contents of another collection to the object where the method is executed.

procedure AssignOrderByCollection(Source: TDABaseOrderByCollection)

Parameters:

Source: Instance whose properties will be copied

GenerateOrderByStatement

Generates ORDER BY statement.

function GenerateOrderByStatement: string

TDAOrderByCollection
- TDASQL92OrderByCollection