TDABetweenExpression

Overview

The TDABetweenExpression class represents the BETWEEN SQL operator in Dynamic Where expressions.

Location

 

constructor Create (TDAWhereExpression, TDAWhereExpression, TDAWhereExpression)  overload

Creates a new expression with the supplied values.

constructor Create(aExpr: TDAWhereExpression; aLower: TDAWhereExpression; aUpper: TDAWhereExpression)

Parameters:

  • aExpr: Dynamic Where expression that is used as argument.
  • aLower: The minimal value of the argument
  • aUpper: The maximum value of the argument

DoValidate  protected    (declared in TDAWhereExpression)

Raised exception if aRaiseException is set

procedure DoValidate(aRaiseException: Boolean; aName: string)

Parameters:

  • aRaiseException: specifies should the exception be raised or not.
  • aName: Name of property

Expression

Dynamic Where expression that is used as argument. The simplest form would be field - TDAFieldExpression.

property Expression: TDAWhereExpression read write

GetWhereKind  protected override

function GetWhereKind: TDAWhereKind

Kind    (declared in TDAWhereExpression)

property Kind: TDAWhereKind read

Lower

The minimal value of the argument, usually a TDAConstantExpression.

property Lower: TDAWhereExpression read write

ParseException  protected    (declared in TDAWhereExpression)

Raises EDAWhereParseXmlException.

procedure ParseException(aName: string)

Parameters:

  • aName: property name.

ParseExpression (IXmlNode, string): TDAWhereExpression  protected overload    (declared in TDAWhereExpression)

Calls ParseException if xr is nil, otherwise calls overload ParseException.

function ParseExpression(xr: IXmlNode; aName: string): TDAWhereExpression

Parameters:

  • xr: source node.
  • aName: Name of property

ParseExpression (IXmlNode): TDAWhereExpression  overload    (declared in TDAWhereExpression)

Creates new Where expression from XML node.

class function ParseExpression(xr: IXmlNode): TDAWhereExpression

Parameters:

  • xr: given XML node.

ReadFromXml  override

Reads where expression from the XML.

procedure ReadFromXml(xr: IXmlNode)

Parameters:

  • xr: source node

RemoveEmptyNodes    (declared in TDAWhereExpression)

class procedure RemoveEmptyNodes(aNode: IXMLNode)

Parameters:

  • aNode:

Upper

The maximum value of the argument, usually a TDAConstantExpression.

property Upper: TDAWhereExpression read write

Validate  override

Validates properties of expression.

procedure Validate

WriteToXml  override

Writes where expression to the XML.

procedure WriteToXml(sw: IXmlNode)

Parameters:

  • sw: destination node

 

Expression

Dynamic Where expression that is used as argument. The simplest form would be field - TDAFieldExpression.

property Expression: TDAWhereExpression read write

Kind    (declared in TDAWhereExpression)

property Kind: TDAWhereKind read

Lower

The minimal value of the argument, usually a TDAConstantExpression.

property Lower: TDAWhereExpression read write

Upper

The maximum value of the argument, usually a TDAConstantExpression.

property Upper: TDAWhereExpression read write

 

ParseExpression (IXmlNode): TDAWhereExpression  overload    (declared in TDAWhereExpression)

Creates new Where expression from XML node.

class function ParseExpression(xr: IXmlNode): TDAWhereExpression

Parameters:

  • xr: given XML node.

RemoveEmptyNodes    (declared in TDAWhereExpression)

class procedure RemoveEmptyNodes(aNode: IXMLNode)

Parameters:

  • aNode:

 

constructor Create (TDAWhereExpression, TDAWhereExpression, TDAWhereExpression)  overload

Creates a new expression with the supplied values.

constructor Create(aExpr: TDAWhereExpression; aLower: TDAWhereExpression; aUpper: TDAWhereExpression)

Parameters:

  • aExpr: Dynamic Where expression that is used as argument.
  • aLower: The minimal value of the argument
  • aUpper: The maximum value of the argument

DoValidate  protected    (declared in TDAWhereExpression)

Raised exception if aRaiseException is set

procedure DoValidate(aRaiseException: Boolean; aName: string)

Parameters:

  • aRaiseException: specifies should the exception be raised or not.
  • aName: Name of property

GetWhereKind  protected override

function GetWhereKind: TDAWhereKind

ParseException  protected    (declared in TDAWhereExpression)

Raises EDAWhereParseXmlException.

procedure ParseException(aName: string)

Parameters:

  • aName: property name.

ParseExpression (IXmlNode, string): TDAWhereExpression  protected overload    (declared in TDAWhereExpression)

Calls ParseException if xr is nil, otherwise calls overload ParseException.

function ParseExpression(xr: IXmlNode; aName: string): TDAWhereExpression

Parameters:

  • xr: source node.
  • aName: Name of property

ReadFromXml  override

Reads where expression from the XML.

procedure ReadFromXml(xr: IXmlNode)

Parameters:

  • xr: source node

Validate  override

Validates properties of expression.

procedure Validate

WriteToXml  override

Writes where expression to the XML.

procedure WriteToXml(sw: IXmlNode)

Parameters:

  • sw: destination node