TDASQL92WhereBuilder

Overview

The TDASQL92WhereBuilder is the descendant of the TDASQLWhereBuilder class and represents a rich set of methods to convert WHERE expressions of different types (binary expression, unary expression, constant expression, etc.) to SQL string.

The TDASQL92WhereBuilder class is used to generate auto SQL statements for all database driver types.

You do not need to use this class directly. It is used by the SQL Editor to build different SQL statements.

Location

 

constructor Create    (declared in TDAWhereBuilder)

Creates a new instance.

constructor Create

constructor Create (IDACustomConnection)  overload    (declared in TDASQLWhereBuilder)

Creates a new instance with a specified database connection.

constructor Create(AConnection: IDACustomConnection)

Parameters:

  • AConnection: specified database connection.

constructor Create (TDASimpleQueryBuilder)  overload    (declared in TDABaseSQLWhereBuilder)

Creates a new TDABaseSQLWhereBuilder object with a specified query builder object.

constructor Create(AQueryBuilder: TDASimpleQueryBuilder)

Parameters:

  • AQueryBuilder: query builder

Clear    (declared in TDAWhereBuilder)

Clears all properties.

procedure Clear

ColumnMapping    (declared in TDAWhereBuilder)

Column mapping.

property ColumnMapping: TDAColumnMappingCollection read write

Connection    (declared in TDASQLWhereBuilder)

Represents the database connection that relates to the current TDASQLWhereBuilder object. This property is read-only.

property Connection: IDACustomConnection read write

CreateWhereClause    (declared in TDABaseSQLWhereBuilder)

Generates Where clause based on Expression

function CreateWhereClause: string

Expression    (declared in TDAWhereBuilder)

Represents Where expressions.

property Expression: TDAWhereExpression read write

ExpressionToXmlNode    (declared in TDAWhereBuilder)

Converts TDAWhereExpression to XML node

function ExpressionToXmlNode(const aExpression: TDAWhereExpression): IXMLNode

Parameters:

  • aExpression: expression

GenerateFieldName  protected virtual    (declared in TDABaseSQLWhereBuilder)

Generates field name according to column mapping and quotation.

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

Parameters:

  • aTablename: table name
  • aFieldName: field name

IsEmpty    (declared in TDAWhereBuilder)

Returns True is Expression is empty.

function IsEmpty: Boolean

NewBetweenExpression (string, string, TDAWhereExpression, TDAWhereExpression): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new BETWEEN condition to the WHERE clause:

aExprTableName.aExprFieldName BETWEEN aLower AND aUpper
function NewBetweenExpression(const aExprTableName: string; const aExprFieldName: string; aLower: TDAWhereExpression; aUpper: TDAWhereExpression): TDAWhereExpression

Parameters:

  • aExprTableName: table name
  • aExprFieldName: field name
  • aLower: The minimal value
  • aUpper: The maximum value

NewBetweenExpression (string, string, variant, variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new BETWEEN condition to the WHERE clause:

aExprTableName.aExprFieldName BETWEEN aLower AND aUpper
function NewBetweenExpression(const aExprTableName: string; const aExprFieldName: string; aLowerValue: variant; aUpperValue: variant; aValuesDataType: TDADataType): TDAWhereExpression

Parameters:

  • aExprTableName: table name
  • aExprFieldName: field name
  • aLowerValue: The minimal value
  • aUpperValue: The maximum value
  • aValuesDataType: data type of aLowerValue and aUpperValue

NewBetweenExpression (TDAWhereExpression, TDAWhereExpression, TDAWhereExpression): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new BETWEEN condition to the WHERE clause:

aExpression BETWEEN aLower AND aUpper
function NewBetweenExpression(aExpression: TDAWhereExpression; aLower: TDAWhereExpression; aUpper: TDAWhereExpression): TDAWhereExpression

Parameters:

  • aExpression: expression
  • aLower: The minimal value
  • aUpper: The maximum value

NewBinaryExpression (string, string, string, TDADataType, TDABinaryOperator): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(const aTableName: string; const aFieldName: string; const aParameterName: string; aParameterType: TDADataType; anOp: TDABinaryOperator): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name
  • aParameterName: parameter name
  • aParameterType: parameter type
  • anOp: operator

NewBinaryExpression (string, string, TDABinaryOperator, variant): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(const aTableName: string; const aFieldName: string; anOp: TDABinaryOperator; const aValue: variant): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name
  • anOp: operator
  • aValue: constant value

NewBinaryExpression (string, string, TDABinaryOperator, variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(const aTableName: string; const aFieldName: string; anOp: TDABinaryOperator; const aValue: variant; aType: TDADataType): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name
  • anOp: operator
  • aValue: constant value
  • aType: data type

NewBinaryExpression (TDAWhereExpression, TDABinaryOperator, variant): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(aLeft: TDAWhereExpression; anOp: TDABinaryOperator; const aValue: variant): TDAWhereExpression

Parameters:

  • aLeft: left expression
  • anOp: operator
  • aValue: constant value

NewBinaryExpression (TDAWhereExpression, TDABinaryOperator, variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(aLeft: TDAWhereExpression; anOp: TDABinaryOperator; const aValue: variant; aType: TDADataType): TDAWhereExpression

Parameters:

  • aLeft: left expression
  • anOp: operator
  • aValue: constant value
  • aType: data type

NewBinaryExpression (TDAWhereExpression, TDAWhereExpression, TDABinaryOperator): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(aLeft: TDAWhereExpression; aRight: TDAWhereExpression; anOp: TDABinaryOperator): TDAWhereExpression

Parameters:

  • aLeft: left expression
  • aRight: right expression
  • anOp: operator

NewBinaryExpressionList    (declared in TDAWhereBuilder)

Adds a new condition to the WHERE clause

function NewBinaryExpressionList(const aExpressions: array of TDAWhereExpression; anOp: TDABinaryOperator): TDAWhereExpression

Parameters:

  • aExpressions: list of expressions
  • anOp: operator

NewConstant (Variant): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new constant condition to the WHERE clause.

function NewConstant(const aValue: Variant): TDAWhereExpression

Parameters:

  • aValue: value

NewConstant (Variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new constant condition to the WHERE clause.

function NewConstant(const aValue: Variant; aType: TDADataType): TDAWhereExpression

Parameters:

  • aValue: value
  • aType: value type

NewField    (declared in TDAWhereBuilder)

Adds a new field condition to the WHERE clause.

function NewField(const aTableName: string; const aFieldName: string): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name

NewIsNotNull  overload    (declared in TDAWhereBuilder)

Adds a new NOT NULL condition to the WHERE clause.

function NewIsNotNull: TDAWhereExpression

NewIsNotNull (string, string): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new NOT NULL condition to the WHERE clause:

aTableName.aFieldName IS NOT NULL
function NewIsNotNull(const aTableName: string; const aFieldName: string): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name

NewList    (declared in TDAWhereBuilder)

Adds a new list condition to the WHERE clause.

function NewList(const aValues: array of TDAWhereExpression): TDAWhereExpression

Parameters:

  • aValues: list of expressions

NewMacro (string): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new macro condition to the WHERE clause.

function NewMacro(const aName: string): TDAWhereExpression

Parameters:

  • aName: macro name

NewMacro (string, array of TDAWhereExpression): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new macro condition to the WHERE clause.

function NewMacro(const aName: string; const aValues: array of TDAWhereExpression): TDAWhereExpression

Parameters:

  • aName: macro name
  • aValues: array of expressions.

NewNull    (declared in TDAWhereBuilder)

Adds a NULL condition to the WHERE clause.

function NewNull: TDAWhereExpression

NewParameter    (declared in TDAWhereBuilder)

Adds a new parameter condition to the WHERE clause.

function NewParameter(const aParameterName: string; aParameterType: TDADataType): TDAWhereExpression

Parameters:

  • aParameterName: parameter name
  • aParameterType: parameter type

NewUnaryExpression    (declared in TDAWhereBuilder)

Adds a new unary condition to the WHERE clause.

function NewUnaryExpression(anExpression: TDAWhereExpression; anOp: TDAUnaryOperator): TDAWhereExpression

Parameters:

  • anExpression: expression
  • anOp: operator

Params    (declared in TDAWhereBuilder)

Provides access to the list of parameters defined for the command.

property Params: TDAParamCollection read write

ProcessBetweenExpression  protected override

Converts the specified between expression to SQL format and returns the SQL string.

function ProcessBetweenExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessBinaryExpression  protected override

Converts the specified binary expression to SQL format and returns the SQL string.

function ProcessBinaryExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessConstantExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified constant expression to SQL format and returns the SQL string.

function ProcessConstantExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessExpression  protected    (declared in TDABaseSQLWhereBuilder)

Converts the specified expression to SQL format and returns the SQL string. The expression can have the following types: BinaryExpression, UnaryExpression, ConstantExpression, ListExpression, ParameterExpression, FieldExpression, NullExpression, MacroExpression or BetweenExpression.

function ProcessExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessFieldExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified field expression to SQL format and returns the SQL string.

function ProcessFieldExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessListExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified list expression to SQL format and returns the SQL string.

function ProcessListExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessMacroExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified macro expression to SQL format and returns the SQL string.

function ProcessMacroExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessNullExpression  protected override

Converts the specified null expression to SQL format and returns the SQL string.

function ProcessNullExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessParameterExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified parameter expression to SQL format and returns the SQL string.

function ProcessParameterExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessUnaryExpression  protected override

Converts the specified unary expression to SQL format and returns the SQL string.

function ProcessUnaryExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

QueryBuilder    (declared in TDABaseSQLWhereBuilder)

Represents the query builder object (TDASimpleQueryBuilder object) that is related to the current TDABaseSQLWhereBuilder object. This property is read-only.

property QueryBuilder: TDASimpleQueryBuilder read write

QuoteFieldName  protected override    (declared in TDASQLWhereBuilder)

Quotes field name

function QuoteFieldName(aTablename: string; aFieldName: string): string

Parameters:

  • aTablename: table name.
  • aFieldName: field name.

ReadFromXml  protected virtual    (declared in TDAWhereBuilder)

Reads Where expression from XML node

function ReadFromXml(xr: IXmlNode): TDAWhereExpression

Parameters:

  • xr: node

WriteToXml  protected virtual    (declared in TDAWhereBuilder)

Writes Where expression to XML node

procedure WriteToXml(sw: IXmlNode; const aExpression: TDAWhereExpression)

Parameters:

  • sw: node
  • aExpression: expression

Xml    (declared in TDAWhereBuilder)

Represent Where expressions as XML node.

property Xml: UnicodeString read write

XMLToExpression    (declared in TDAWhereBuilder)

Reads Where expression from XML

function XMLToExpression(const aXML: UnicodeString): TDAWhereExpression

Parameters:

  • aXML: given XML

 

ColumnMapping    (declared in TDAWhereBuilder)

Column mapping.

property ColumnMapping: TDAColumnMappingCollection read write

Connection    (declared in TDASQLWhereBuilder)

Represents the database connection that relates to the current TDASQLWhereBuilder object. This property is read-only.

property Connection: IDACustomConnection read write

Expression    (declared in TDAWhereBuilder)

Represents Where expressions.

property Expression: TDAWhereExpression read write

Params    (declared in TDAWhereBuilder)

Provides access to the list of parameters defined for the command.

property Params: TDAParamCollection read write

QueryBuilder    (declared in TDABaseSQLWhereBuilder)

Represents the query builder object (TDASimpleQueryBuilder object) that is related to the current TDABaseSQLWhereBuilder object. This property is read-only.

property QueryBuilder: TDASimpleQueryBuilder read write

Xml    (declared in TDAWhereBuilder)

Represent Where expressions as XML node.

property Xml: UnicodeString read write

 

constructor Create    (declared in TDAWhereBuilder)

Creates a new instance.

constructor Create

constructor Create (IDACustomConnection)  overload    (declared in TDASQLWhereBuilder)

Creates a new instance with a specified database connection.

constructor Create(AConnection: IDACustomConnection)

Parameters:

  • AConnection: specified database connection.

constructor Create (TDASimpleQueryBuilder)  overload    (declared in TDABaseSQLWhereBuilder)

Creates a new TDABaseSQLWhereBuilder object with a specified query builder object.

constructor Create(AQueryBuilder: TDASimpleQueryBuilder)

Parameters:

  • AQueryBuilder: query builder

Clear    (declared in TDAWhereBuilder)

Clears all properties.

procedure Clear

CreateWhereClause    (declared in TDABaseSQLWhereBuilder)

Generates Where clause based on Expression

function CreateWhereClause: string

ExpressionToXmlNode    (declared in TDAWhereBuilder)

Converts TDAWhereExpression to XML node

function ExpressionToXmlNode(const aExpression: TDAWhereExpression): IXMLNode

Parameters:

  • aExpression: expression

GenerateFieldName  protected virtual    (declared in TDABaseSQLWhereBuilder)

Generates field name according to column mapping and quotation.

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

Parameters:

  • aTablename: table name
  • aFieldName: field name

IsEmpty    (declared in TDAWhereBuilder)

Returns True is Expression is empty.

function IsEmpty: Boolean

NewBetweenExpression (string, string, TDAWhereExpression, TDAWhereExpression): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new BETWEEN condition to the WHERE clause:

aExprTableName.aExprFieldName BETWEEN aLower AND aUpper
function NewBetweenExpression(const aExprTableName: string; const aExprFieldName: string; aLower: TDAWhereExpression; aUpper: TDAWhereExpression): TDAWhereExpression

Parameters:

  • aExprTableName: table name
  • aExprFieldName: field name
  • aLower: The minimal value
  • aUpper: The maximum value

NewBetweenExpression (string, string, variant, variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new BETWEEN condition to the WHERE clause:

aExprTableName.aExprFieldName BETWEEN aLower AND aUpper
function NewBetweenExpression(const aExprTableName: string; const aExprFieldName: string; aLowerValue: variant; aUpperValue: variant; aValuesDataType: TDADataType): TDAWhereExpression

Parameters:

  • aExprTableName: table name
  • aExprFieldName: field name
  • aLowerValue: The minimal value
  • aUpperValue: The maximum value
  • aValuesDataType: data type of aLowerValue and aUpperValue

NewBetweenExpression (TDAWhereExpression, TDAWhereExpression, TDAWhereExpression): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new BETWEEN condition to the WHERE clause:

aExpression BETWEEN aLower AND aUpper
function NewBetweenExpression(aExpression: TDAWhereExpression; aLower: TDAWhereExpression; aUpper: TDAWhereExpression): TDAWhereExpression

Parameters:

  • aExpression: expression
  • aLower: The minimal value
  • aUpper: The maximum value

NewBinaryExpression (string, string, string, TDADataType, TDABinaryOperator): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(const aTableName: string; const aFieldName: string; const aParameterName: string; aParameterType: TDADataType; anOp: TDABinaryOperator): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name
  • aParameterName: parameter name
  • aParameterType: parameter type
  • anOp: operator

NewBinaryExpression (string, string, TDABinaryOperator, variant): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(const aTableName: string; const aFieldName: string; anOp: TDABinaryOperator; const aValue: variant): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name
  • anOp: operator
  • aValue: constant value

NewBinaryExpression (string, string, TDABinaryOperator, variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(const aTableName: string; const aFieldName: string; anOp: TDABinaryOperator; const aValue: variant; aType: TDADataType): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name
  • anOp: operator
  • aValue: constant value
  • aType: data type

NewBinaryExpression (TDAWhereExpression, TDABinaryOperator, variant): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(aLeft: TDAWhereExpression; anOp: TDABinaryOperator; const aValue: variant): TDAWhereExpression

Parameters:

  • aLeft: left expression
  • anOp: operator
  • aValue: constant value

NewBinaryExpression (TDAWhereExpression, TDABinaryOperator, variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(aLeft: TDAWhereExpression; anOp: TDABinaryOperator; const aValue: variant; aType: TDADataType): TDAWhereExpression

Parameters:

  • aLeft: left expression
  • anOp: operator
  • aValue: constant value
  • aType: data type

NewBinaryExpression (TDAWhereExpression, TDAWhereExpression, TDABinaryOperator): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new comparison condition to the WHERE clause

function NewBinaryExpression(aLeft: TDAWhereExpression; aRight: TDAWhereExpression; anOp: TDABinaryOperator): TDAWhereExpression

Parameters:

  • aLeft: left expression
  • aRight: right expression
  • anOp: operator

NewBinaryExpressionList    (declared in TDAWhereBuilder)

Adds a new condition to the WHERE clause

function NewBinaryExpressionList(const aExpressions: array of TDAWhereExpression; anOp: TDABinaryOperator): TDAWhereExpression

Parameters:

  • aExpressions: list of expressions
  • anOp: operator

NewConstant (Variant): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new constant condition to the WHERE clause.

function NewConstant(const aValue: Variant): TDAWhereExpression

Parameters:

  • aValue: value

NewConstant (Variant, TDADataType): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new constant condition to the WHERE clause.

function NewConstant(const aValue: Variant; aType: TDADataType): TDAWhereExpression

Parameters:

  • aValue: value
  • aType: value type

NewField    (declared in TDAWhereBuilder)

Adds a new field condition to the WHERE clause.

function NewField(const aTableName: string; const aFieldName: string): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name

NewIsNotNull  overload    (declared in TDAWhereBuilder)

Adds a new NOT NULL condition to the WHERE clause.

function NewIsNotNull: TDAWhereExpression

NewIsNotNull (string, string): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new NOT NULL condition to the WHERE clause:

aTableName.aFieldName IS NOT NULL
function NewIsNotNull(const aTableName: string; const aFieldName: string): TDAWhereExpression

Parameters:

  • aTableName: table name
  • aFieldName: field name

NewList    (declared in TDAWhereBuilder)

Adds a new list condition to the WHERE clause.

function NewList(const aValues: array of TDAWhereExpression): TDAWhereExpression

Parameters:

  • aValues: list of expressions

NewMacro (string): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new macro condition to the WHERE clause.

function NewMacro(const aName: string): TDAWhereExpression

Parameters:

  • aName: macro name

NewMacro (string, array of TDAWhereExpression): TDAWhereExpression  overload    (declared in TDAWhereBuilder)

Adds a new macro condition to the WHERE clause.

function NewMacro(const aName: string; const aValues: array of TDAWhereExpression): TDAWhereExpression

Parameters:

  • aName: macro name
  • aValues: array of expressions.

NewNull    (declared in TDAWhereBuilder)

Adds a NULL condition to the WHERE clause.

function NewNull: TDAWhereExpression

NewParameter    (declared in TDAWhereBuilder)

Adds a new parameter condition to the WHERE clause.

function NewParameter(const aParameterName: string; aParameterType: TDADataType): TDAWhereExpression

Parameters:

  • aParameterName: parameter name
  • aParameterType: parameter type

NewUnaryExpression    (declared in TDAWhereBuilder)

Adds a new unary condition to the WHERE clause.

function NewUnaryExpression(anExpression: TDAWhereExpression; anOp: TDAUnaryOperator): TDAWhereExpression

Parameters:

  • anExpression: expression
  • anOp: operator

ProcessBetweenExpression  protected override

Converts the specified between expression to SQL format and returns the SQL string.

function ProcessBetweenExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessBinaryExpression  protected override

Converts the specified binary expression to SQL format and returns the SQL string.

function ProcessBinaryExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessConstantExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified constant expression to SQL format and returns the SQL string.

function ProcessConstantExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessExpression  protected    (declared in TDABaseSQLWhereBuilder)

Converts the specified expression to SQL format and returns the SQL string. The expression can have the following types: BinaryExpression, UnaryExpression, ConstantExpression, ListExpression, ParameterExpression, FieldExpression, NullExpression, MacroExpression or BetweenExpression.

function ProcessExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessFieldExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified field expression to SQL format and returns the SQL string.

function ProcessFieldExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessListExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified list expression to SQL format and returns the SQL string.

function ProcessListExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessMacroExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified macro expression to SQL format and returns the SQL string.

function ProcessMacroExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessNullExpression  protected override

Converts the specified null expression to SQL format and returns the SQL string.

function ProcessNullExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessParameterExpression  protected virtual    (declared in TDABaseSQLWhereBuilder)

Converts the specified parameter expression to SQL format and returns the SQL string.

function ProcessParameterExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

ProcessUnaryExpression  protected override

Converts the specified unary expression to SQL format and returns the SQL string.

function ProcessUnaryExpression(AExpression: TDAWhereExpression): string

Parameters:

  • AExpression: expression

QuoteFieldName  protected override    (declared in TDASQLWhereBuilder)

Quotes field name

function QuoteFieldName(aTablename: string; aFieldName: string): string

Parameters:

  • aTablename: table name.
  • aFieldName: field name.

ReadFromXml  protected virtual    (declared in TDAWhereBuilder)

Reads Where expression from XML node

function ReadFromXml(xr: IXmlNode): TDAWhereExpression

Parameters:

  • xr: node

WriteToXml  protected virtual    (declared in TDAWhereBuilder)

Writes Where expression to XML node

procedure WriteToXml(sw: IXmlNode; const aExpression: TDAWhereExpression)

Parameters:

  • sw: node
  • aExpression: expression

XMLToExpression    (declared in TDAWhereBuilder)

Reads Where expression from XML

function XMLToExpression(const aXML: UnicodeString): TDAWhereExpression

Parameters:

  • aXML: given XML

See Also