TDASqlProcessor
Overview
TDASqlProcessor provides the core logic for processing DA SQL queries.
Required steps:
- drop TDASqlProcessor to DAService
- link it to DAService.DASQLProcessor property
- set DAService.AllowExecuteDASQL to True
Location
- Unit: uDASQLProcessor.pas
- Ancestry: TComponent | TDASqlProcessor
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)