TDADateTimePartExpression

Overview

The TDADateTimePartExpression class represents a call to the SQL function that extracts a part of given date in Dynamic Where expressions.

Date parts that can be extracted:

 
Year Month Week Day Hour Minute Second

Location

 

constructor Create (TDAWhereExpression, TDADateTimePart)  overload

Creates a new expression with a supplied values.

constructor Create(anExpression: TDAWhereExpression; aPart: TDADateTimePart)

Parameters:

  • anExpression:
  • aPart:

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

Expression

property Expression: TDAWhereExpression read write

Kind    (declared in TDAWhereExpression)

Specified kind of TDAWhereExpression

property Kind: TDAWhereKind read

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.

Part

Part of date or time

property Part: TDADateTimePart read write

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

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

Expression

property Expression: TDAWhereExpression read write

Kind    (declared in TDAWhereExpression)

Specified kind of TDAWhereExpression

property Kind: TDAWhereKind read

Part

Part of date or time

property Part: TDADateTimePart 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, TDADateTimePart)  overload

Creates a new expression with a supplied values.

constructor Create(anExpression: TDAWhereExpression; aPart: TDADateTimePart)

Parameters:

  • anExpression:
  • aPart:

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