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


 

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)

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)

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