TDAOrderByCollection

Overview

TDAOrderByCollection adds connection support to TDABaseOrderByCollection.

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: uDAQueryBuilder.pas
Ancestry: TCollection | TDABaseOrderByCollection | TDAOrderByCollection

constructor Create (IDACustomConnection) reintroduce overload

Creates a new instance.

constructor Create(aConnection: IDACustomConnection)

Parameters:

aConnection: connection

constructor Create (TDASimpleQueryBuilder) reintroduce overload (declared in TDABaseOrderByCollection)

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

constructor Create(aQueryBuilder: TDASimpleQueryBuilder)

Parameters:

aQueryBuilder: query builder

Assign override (declared in TDABaseOrderByCollection)

Copies data from a given source.

procedure Assign(Source: TPersistent)

Parameters:

Source: Instance whose properties will be copied

AssignOrderByCollection virtual (declared in TDABaseOrderByCollection)

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

CreateFieldGenerator protected virtual abstract

Creates TDAFieldGenerator.

function CreateFieldGenerator: TDAFieldGenerator

FieldGenerator (declared in TDABaseOrderByCollection)

Referense to TDABaseFieldGenerator that contains rules for generating field name

property FieldGenerator: TDABaseFieldGenerator read write

GenerateOrderByStatement (declared in TDABaseOrderByCollection)

Generates ORDER BY statement.

function GenerateOrderByStatement: string

Items (declared in TDABaseOrderByCollection)

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

property Items[Index: Integer]: TDAOrderByItem read write

OwnFieldGenerator (declared in TDABaseOrderByCollection)

Uses own generator or not

property OwnFieldGenerator: Boolean read write

FieldGenerator (declared in TDABaseOrderByCollection)

Referense to TDABaseFieldGenerator that contains rules for generating field name

property FieldGenerator: TDABaseFieldGenerator read write

Items (declared in TDABaseOrderByCollection)

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

property Items[Index: Integer]: TDAOrderByItem read write

OwnFieldGenerator (declared in TDABaseOrderByCollection)

Uses own generator or not

property OwnFieldGenerator: Boolean read write

constructor Create (IDACustomConnection) reintroduce overload

Creates a new instance.

constructor Create(aConnection: IDACustomConnection)

Parameters:

aConnection: connection

constructor Create (TDASimpleQueryBuilder) reintroduce overload (declared in TDABaseOrderByCollection)

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

constructor Create(aQueryBuilder: TDASimpleQueryBuilder)

Parameters:

aQueryBuilder: query builder

Assign override (declared in TDABaseOrderByCollection)

Copies data from a given source.

procedure Assign(Source: TPersistent)

Parameters:

Source: Instance whose properties will be copied

AssignOrderByCollection virtual (declared in TDABaseOrderByCollection)

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

CreateFieldGenerator protected virtual abstract

Creates TDAFieldGenerator.

function CreateFieldGenerator: TDAFieldGenerator

GenerateOrderByStatement (declared in TDABaseOrderByCollection)

Generates ORDER BY statement.

function GenerateOrderByStatement: string

TDASQL92OrderByCollection