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

AsJson    (declared in TDAWhereExpression)

Returns where expression in Json format

function AsJson: UnicodeString

AsXML    (declared in TDAWhereExpression)

Returns where expression in XML format

function AsXML: UnicodeString

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

Kind    (declared in TDAWhereExpression)

Specified kind of 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 (TROJSONObject, string): TDAWhereExpression  protected overload    (declared in TDAWhereExpression)

Creates new Where expression from Json object.

function ParseExpression(aItem: TROJSONObject; aName: string): TDAWhereExpression

Parameters:

  • aItem: Json object
  • aName: Name of property

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

Creates new Where expression from XML node.

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

Parameters:

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

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

Creates new Where expression from Json object.

class function ParseExpression(anItem: TROJSONObject): TDAWhereExpression

Parameters:

  • anItem: json object

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.

ReadFromJson  override

Reads where expression from the Json.

procedure ReadFromJson(aItem: TROJSONObject)

Parameters:

  • aItem: Json object

ReadFromXml  override

Reads where expression from the XML.

procedure ReadFromXml(xr: IXmlNode)

Parameters:

  • xr: source node

RemoveEmptyNodes    (declared in TDAWhereExpression)

Removes empty XML nodes from given node

class procedure RemoveEmptyNodes(aNode: IXMLNode)

Parameters:

  • aNode: node

Upper

The maximum value of the argument, usually a TDAConstantExpression.

property Upper: TDAWhereExpression read write

Validate  override

Validates properties of expression.

procedure Validate

WriteToJson  override

Writes where expression to the Json object.

procedure WriteToJson(aItem: TROJSONObject)

Parameters:

  • aItem: destination object

WriteToXml  override

Writes where expression to the XML node.

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)

Specified kind of 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 (TROJSONObject): TDAWhereExpression  overload    (declared in TDAWhereExpression)

Creates new Where expression from Json object.

class function ParseExpression(anItem: TROJSONObject): TDAWhereExpression

Parameters:

  • anItem: json object

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)

Removes empty XML nodes from given node

class procedure RemoveEmptyNodes(aNode: IXMLNode)

Parameters:

  • aNode: node

 

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

AsJson    (declared in TDAWhereExpression)

Returns where expression in Json format

function AsJson: UnicodeString

AsXML    (declared in TDAWhereExpression)

Returns where expression in XML format

function AsXML: UnicodeString

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

ParseException  protected    (declared in TDAWhereExpression)

Raises EDAWhereParseXmlException.

procedure ParseException(aName: string)

Parameters:

  • aName: property name.

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

Creates new Where expression from Json object.

function ParseExpression(aItem: TROJSONObject; aName: string): TDAWhereExpression

Parameters:

  • aItem: Json object
  • aName: Name of property

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

Creates new Where expression from XML node.

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

Parameters:

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

ReadFromJson  override

Reads where expression from the Json.

procedure ReadFromJson(aItem: TROJSONObject)

Parameters:

  • aItem: Json object

ReadFromXml  override

Reads where expression from the XML.

procedure ReadFromXml(xr: IXmlNode)

Parameters:

  • xr: source node

Validate  override

Validates properties of expression.

procedure Validate

WriteToJson  override

Writes where expression to the Json object.

procedure WriteToJson(aItem: TROJSONObject)

Parameters:

  • aItem: destination object

WriteToXml  override

Writes where expression to the XML node.

procedure WriteToXml(sw: IXmlNode)

Parameters:

  • sw: destination node