TDASelectWhereField

Overview

The TDASelectWhereField class represents the similar field in the Fields collection of the TDASelectWhereBuilder class.

The TDASelectWhereBuilder is used to create dynamic SELECT and WHERE statements of any SQL statement. The TDASelectWhereField and TDASelectWhereBuilder classes are obsolete and used only for backward compatibility.

For creating dynamic statements, see the articles Dynamic Select, Dynamic Where and Dynamic Request.

Location

 

constructor Create (TDASelectWhereBuilder)  overload

Creates a new instance.

constructor Create(anOwner: TDASelectWhereBuilder)

Parameters:

  • anOwner: Specified owner

constructor Create (TDASelectWhereBuilder, string)  overload

Creates a new instance with the specified owner anOwner and the field name aFieldName.

constructor Create(anOwner: TDASelectWhereBuilder; const aFieldName: string)

Parameters:

  • anOwner: Specified owner of the current object
  • aFieldName: Specified field name of the current object

constructor Create (TDASelectWhereBuilder, string, string)  overload

Creates a new instance with the specified owner anOwner, the field name aFieldName and the alias name anAlias.

constructor Create(anOwner: TDASelectWhereBuilder; const aFieldName: string; const anAlias: string)

Parameters:

  • anOwner: Specified owner of the current object
  • aFieldName: Specified field name of the current object
  • anAlias: Specified alias name of the current object

Alias

Represents the alias name of the current TDASelectWhereField object.

property Alias: string read write

FieldName

Represents the field name of the current TDASelectWhereField object.

property FieldName: string read write

Owner    (declared in TDASelectWhereItem)

Represents the specified TDASelectWhereBuilder that contains dynamic SELECT and WHERE statements of the SQL statement.

property Owner: TDASelectWhereBuilder read write

ReadFromXml  override

Virtual public function that reads the specified TDASelectWhereField object from the XML file. xr contains the complete information about the TDASelectWhereField object in XML format.
If the XML node xr does not contain the initial node field, the method raises an exception.

procedure ReadFromXml(xr: IXmlNode)

Parameters:

  • xr: Contains the complete information about the TDASelectWhereField object in XML format

WriteToXml  override

Virtual public function that writes the current TDASelectWhereField object to the XML node sw.

procedure WriteToXml(sw: IXmlNode)

Parameters:

  • sw: Output XML node that will contain the TDASelectWhereField object in XML format

 

Alias

Represents the alias name of the current TDASelectWhereField object.

property Alias: string read write

FieldName

Represents the field name of the current TDASelectWhereField object.

property FieldName: string read write

Owner    (declared in TDASelectWhereItem)

Represents the specified TDASelectWhereBuilder that contains dynamic SELECT and WHERE statements of the SQL statement.

property Owner: TDASelectWhereBuilder read write

 

constructor Create (TDASelectWhereBuilder)  overload

Creates a new instance.

constructor Create(anOwner: TDASelectWhereBuilder)

Parameters:

  • anOwner: Specified owner

constructor Create (TDASelectWhereBuilder, string)  overload

Creates a new instance with the specified owner anOwner and the field name aFieldName.

constructor Create(anOwner: TDASelectWhereBuilder; const aFieldName: string)

Parameters:

  • anOwner: Specified owner of the current object
  • aFieldName: Specified field name of the current object

constructor Create (TDASelectWhereBuilder, string, string)  overload

Creates a new instance with the specified owner anOwner, the field name aFieldName and the alias name anAlias.

constructor Create(anOwner: TDASelectWhereBuilder; const aFieldName: string; const anAlias: string)

Parameters:

  • anOwner: Specified owner of the current object
  • aFieldName: Specified field name of the current object
  • anAlias: Specified alias name of the current object

ReadFromXml  override

Virtual public function that reads the specified TDASelectWhereField object from the XML file. xr contains the complete information about the TDASelectWhereField object in XML format.
If the XML node xr does not contain the initial node field, the method raises an exception.

procedure ReadFromXml(xr: IXmlNode)

Parameters:

  • xr: Contains the complete information about the TDASelectWhereField object in XML format

WriteToXml  override

Virtual public function that writes the current TDASelectWhereField object to the XML node sw.

procedure WriteToXml(sw: IXmlNode)

Parameters:

  • sw: Output XML node that will contain the TDASelectWhereField object in XML format

See Also