TDASqlProcessor

Overview

TDASqlProcessor provides the core logic for processing DA SQL queries.

Required steps:

Location

 

constructor Create  override

Creates an new instance

constructor Create(AOwner: TComponent)

Parameters:

  • AOwner:

AllowMacroSupport

property AllowMacroSupport: Boolean read write

CheckProperties

procedure CheckProperties

GetData (string, string, TDAWhereExpression, DataParameterArray, IDAConnection, TDASchema, TDADataStreamer, Integer, Boolean)  overload

procedure GetData(aTableName: string; aSql: string; aAdditionalWhere: TDAWhereExpression; aParameters: DataParameterArray; aConnection: IDAConnection; aServiceSchema: TDASchema; aStreamer: TDADataStreamer; aMaxRecords: Integer; aAllowPrivateAccess: Boolean)

Parameters:

  • aTableName:
  • aSql:
  • aAdditionalWhere:
  • aParameters:
  • aConnection:
  • aServiceSchema:
  • aStreamer:
  • aMaxRecords:
  • aAllowPrivateAccess:

GetData (string, string, TDAWhereExpression, DataParameterArray, TDADataStreamer)  overload

procedure GetData(aTableName: string; aSql: string; aAdditionalWhere: TDAWhereExpression; aParameters: DataParameterArray; aStreamer: TDADataStreamer)

Parameters:

  • aTableName:
  • aSql:
  • aAdditionalWhere:
  • aParameters:
  • aStreamer:

GetData (string, string, DataParameterArray, TDADataStreamer)  overload

procedure GetData(aTableName: string; aSql: string; aParameters: DataParameterArray; aStreamer: TDADataStreamer)

Parameters:

  • aTableName:
  • aSql:
  • aParameters:
  • aStreamer:

InjectDynWhere

class procedure InjectDynWhere(aQuery: TQueryExpression; aExpression: TDAWhereExpression)

Parameters:

  • aQuery:
  • aExpression:

OnAdjustCalculatedFields

property OnAdjustCalculatedFields: TDAAdjustCalcFields read write
delegate: procedure OnAdjustCalculatedFields(aTableName: string; var aField: TDAField)

OnValidateTable

property OnValidateTable: TDAValidateTableEvent read write
delegate: procedure OnValidateTable(aTableName: string; var aConnection: IDAConnection)

Service

property Service: TRORemoteDataModule read write

 

AllowMacroSupport

property AllowMacroSupport: Boolean read write

Service

property Service: TRORemoteDataModule read write

 

InjectDynWhere

class procedure InjectDynWhere(aQuery: TQueryExpression; aExpression: TDAWhereExpression)

Parameters:

  • aQuery:
  • aExpression:

 

constructor Create  override

Creates an new instance

constructor Create(AOwner: TComponent)

Parameters:

  • AOwner:

CheckProperties

procedure CheckProperties

GetData (string, string, TDAWhereExpression, DataParameterArray, IDAConnection, TDASchema, TDADataStreamer, Integer, Boolean)  overload

procedure GetData(aTableName: string; aSql: string; aAdditionalWhere: TDAWhereExpression; aParameters: DataParameterArray; aConnection: IDAConnection; aServiceSchema: TDASchema; aStreamer: TDADataStreamer; aMaxRecords: Integer; aAllowPrivateAccess: Boolean)

Parameters:

  • aTableName:
  • aSql:
  • aAdditionalWhere:
  • aParameters:
  • aConnection:
  • aServiceSchema:
  • aStreamer:
  • aMaxRecords:
  • aAllowPrivateAccess:

GetData (string, string, TDAWhereExpression, DataParameterArray, TDADataStreamer)  overload

procedure GetData(aTableName: string; aSql: string; aAdditionalWhere: TDAWhereExpression; aParameters: DataParameterArray; aStreamer: TDADataStreamer)

Parameters:

  • aTableName:
  • aSql:
  • aAdditionalWhere:
  • aParameters:
  • aStreamer:

GetData (string, string, DataParameterArray, TDADataStreamer)  overload

procedure GetData(aTableName: string; aSql: string; aParameters: DataParameterArray; aStreamer: TDADataStreamer)

Parameters:

  • aTableName:
  • aSql:
  • aParameters:
  • aStreamer:

 

OnAdjustCalculatedFields

property OnAdjustCalculatedFields: TDAAdjustCalcFields read write
delegate: procedure OnAdjustCalculatedFields(aTableName: string; var aField: TDAField)

OnValidateTable

property OnValidateTable: TDAValidateTableEvent read write
delegate: procedure OnValidateTable(aTableName: string; var aConnection: IDAConnection)