TDAOrderByItem

Overview

TDAOrderByItem specifies how to the field should be sorted.

Usage: TDAOrderByItem is used indirectly in TDASQL92QueryBuilder.AddOrderBy: 

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

 

AscMode

Specifies sort mode

property AscMode: Boolean read write

Assign  override

Copies data from a given source.

procedure Assign(Source: TPersistent)

Parameters:

  • Source: Instance whose properties will be copied

AssignOrderBy

Assigns the AscMode and ancestor's properties.

procedure AssignOrderBy(Source: TDAOrderByItem)

Parameters:

  • Source: Instance whose properties will be copied

AssignTableField    (declared in TDATableFieldCollectionItem)

Assigns the FieldName and TableName.

procedure AssignTableField(Source: TDATableFieldCollectionItem)

Parameters:

  • Source: Instance whose properties will be copied

FieldName    (declared in TDATableFieldCollectionItem)

Represents the name of the field in the data table in the database. Note that this name is not the schema field name, but the field name from the database.

property FieldName: string read write

TableName    (declared in TDATableFieldCollectionItem)

Represents the name of the table in the database. Not mandatory. Note that this name is not the schema table name, but the table name from the database.

property TableName: string read write

 

AscMode

Specifies sort mode

property AscMode: Boolean read write

FieldName    (declared in TDATableFieldCollectionItem)

Represents the name of the field in the data table in the database. Note that this name is not the schema field name, but the field name from the database.

property FieldName: string read write

TableName    (declared in TDATableFieldCollectionItem)

Represents the name of the table in the database. Not mandatory. Note that this name is not the schema table name, but the table name from the database.

property TableName: string read write

 

Assign  override

Copies data from a given source.

procedure Assign(Source: TPersistent)

Parameters:

  • Source: Instance whose properties will be copied

AssignOrderBy

Assigns the AscMode and ancestor's properties.

procedure AssignOrderBy(Source: TDAOrderByItem)

Parameters:

  • Source: Instance whose properties will be copied

AssignTableField    (declared in TDATableFieldCollectionItem)

Assigns the FieldName and TableName.

procedure AssignTableField(Source: TDATableFieldCollectionItem)

Parameters:

  • Source: Instance whose properties will be copied