TDASQL92FieldGenerator

Overview

TDASQL92FieldGenerator generates field names according to the SQL92 standard via checking SQL92 standard's reserved words.

This class is used automatically by TDASQL92QueryBuilder.

Location

 

constructor Create  reintroduce overload    (declared in TDABaseFieldGenerator)

Creates a new instance.

constructor Create

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

Creates a new instance with given parameter.

constructor Create(AQueryBuilder: TDASimpleQueryBuilder)

Parameters:

  • AQueryBuilder: query builder

AlwaysQuoteFieldName    (declared in TDABaseFieldGenerator)

Changes the behavior of QuoteFieldNameIfNeeded method.

property AlwaysQuoteFieldName: Boolean read write

Assign  override    (declared in TDAFieldGenerator)

Copies the contents of another instance to the object where the method is executed

procedure Assign(Source: TPersistent)

Parameters:

  • Source: Instance whose properties will be copied

ColumnMapping    (declared in TDABaseFieldGenerator)

Column mapping.

property ColumnMapping: TDAColumnMappingCollection read write

Connection    (declared in TDAFieldGenerator)

Active connection

property Connection: IDACustomConnection read write

GenerateFieldName    (declared in TDABaseFieldGenerator)

Generates field name according to column mapping and quotation.

function GenerateFieldName(aTablename: string; aFieldName: string; aProcessMapping: Boolean): string

Parameters:

  • aTablename: table name
  • aFieldName: field name
  • aProcessMapping: Controls if GetMappingTableField is applied to aFieldName. true by default.

GetMappingTableField  protected    (declared in TDABaseFieldGenerator)

Returns correspondent name from column mapping.

function GetMappingTableField(const aDataSetField: string): string

Parameters:

  • aDataSetField: dataset field

IdentifierNeedsQuoting  protected override

Checks if identifier need to be quoted.

function IdentifierNeedsQuoting(const iIdentifier: string): boolean

Parameters:

  • iIdentifier: identifier.

QuoteFieldNameIfNeeded  protected override    (declared in TDAFieldGenerator)

Quotes field name if is required.

function QuoteFieldNameIfNeeded(const aTableName: string; const aFieldName: string): string

Parameters:

  • aTableName: table name.
  • aFieldName: field name.

QuoteIdentifier  protected override    (declared in TDAFieldGenerator)

Quotes identifier.

function QuoteIdentifier(const iIdentifier: string): string

Parameters:

  • iIdentifier: identifier.

QuoteIdentifierIfNeeded  protected override    (declared in TDAFieldGenerator)

Quotes identifier if is required.

function QuoteIdentifierIfNeeded(const iIdentifier: string): string

Parameters:

  • iIdentifier: identifier.

 

AlwaysQuoteFieldName    (declared in TDABaseFieldGenerator)

Changes the behavior of QuoteFieldNameIfNeeded method.

property AlwaysQuoteFieldName: Boolean read write

ColumnMapping    (declared in TDABaseFieldGenerator)

Column mapping.

property ColumnMapping: TDAColumnMappingCollection read write

Connection    (declared in TDAFieldGenerator)

Active connection

property Connection: IDACustomConnection read write

 

constructor Create  reintroduce overload    (declared in TDABaseFieldGenerator)

Creates a new instance.

constructor Create

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

Creates a new instance with given parameter.

constructor Create(AQueryBuilder: TDASimpleQueryBuilder)

Parameters:

  • AQueryBuilder: query builder

Assign  override    (declared in TDAFieldGenerator)

Copies the contents of another instance to the object where the method is executed

procedure Assign(Source: TPersistent)

Parameters:

  • Source: Instance whose properties will be copied

GenerateFieldName    (declared in TDABaseFieldGenerator)

Generates field name according to column mapping and quotation.

function GenerateFieldName(aTablename: string; aFieldName: string; aProcessMapping: Boolean): string

Parameters:

  • aTablename: table name
  • aFieldName: field name
  • aProcessMapping: Controls if GetMappingTableField is applied to aFieldName. true by default.

GetMappingTableField  protected    (declared in TDABaseFieldGenerator)

Returns correspondent name from column mapping.

function GetMappingTableField(const aDataSetField: string): string

Parameters:

  • aDataSetField: dataset field

IdentifierNeedsQuoting  protected override

Checks if identifier need to be quoted.

function IdentifierNeedsQuoting(const iIdentifier: string): boolean

Parameters:

  • iIdentifier: identifier.

QuoteFieldNameIfNeeded  protected override    (declared in TDAFieldGenerator)

Quotes field name if is required.

function QuoteFieldNameIfNeeded(const aTableName: string; const aFieldName: string): string

Parameters:

  • aTableName: table name.
  • aFieldName: field name.

QuoteIdentifier  protected override    (declared in TDAFieldGenerator)

Quotes identifier.

function QuoteIdentifier(const iIdentifier: string): string

Parameters:

  • iIdentifier: identifier.

QuoteIdentifierIfNeeded  protected override    (declared in TDAFieldGenerator)

Quotes identifier if is required.

function QuoteIdentifierIfNeeded(const iIdentifier: string): string

Parameters:

  • iIdentifier: identifier.

See Also