TDABusinessProcessor

 

Standard component constructor

constructor Create(aOwner: TComponent)

Parameters:

• aOwner: Owner

---

Copies the contents of another, similar object.

procedure Assign(Source: TPersistent)

Parameters:

• Source: Instance whose properties will be copied

---

Used for associating current strongly typed business processor to a business helper class . It should correspond to a value used in RegisterBusinessProcessorRules method, called in initialization section of the business helper class unit.

property BusinessRulesID: string read write

---

Validates the business processor properties.

procedure CheckProperties

---

Creates mapping for specific command

procedure CreateMappings(const aDelta: IDADelta; out MappingArray: TDAParamMappingArray; const aCommand: IDASQLCommand; lAdditionalMapping: TDAColumnMappingCollection; AValidateCommand: Boolean)

Parameters:

• aDelta: Delta
• MappingArray: Mapping array
• aCommand: Command
• lAdditionalMapping: Additional mapping
• AValidateCommand: Validate command

---

This is an individual changed record currently being processed.

property CurrentChange: TDADeltaChange read

---

CurrentDelta is the set of changes currently to be transmitted between client and server.

property CurrentDelta: TDADelta read

---

This command will be used to apply DELETE changes for the data table back to the server. This property only needs to be assigned if your schema provides a special command for processing DELETE changes (which could be an SQL DELETE statement or a stored procedure). To make the Business Processor use this command, remove poAutoGenerateDelete in the ProcessorOptions; if poAutoGenerateDelete is specified, the Business Processor will automatically generate the necessary SQL code to perform the DELETE on the database.

property DeleteCommandName: string read write

---

Fires AfterExecuteCommand event.

procedure DoAfterExecuteCommandEvent(const ACommand: IDASQLCommand; CommandName: string; ElapsedMilliseconds: Cardinal)

Parameters:

• ACommand: command
• CommandName: command name
• ElapsedMilliseconds: time of execution of command

---

Fires AfterProcessChange event.

procedure DoAfterProcessChangeEvent(aChange: TDADeltaChange; Processed: Boolean; var CanRemoveFromDelta: Boolean)

Parameters:

• aChange: Change
• Processed: Status of change
• CanRemoveFromDelta: Remove change from delta or not.

---

Fires OnAfterProcessDelta

procedure DoAfterProcessDeltaEvent(const aDelta: IDADelta)

Parameters:

• aDelta: Delta

---

Fires BeforeExecuteCommand event.

procedure DoBeforeExecuteCommandEvent(const ACommand: IDASQLCommand; CommandName: string)

Parameters:

• ACommand: Command
• CommandName: Command name

---

Fires OnBeforeProcessChange

procedure DoBeforeProcessChangeEvent(aChange: TDADeltaChange; var ProcessChange: Boolean; var CanRemoveFromDelta: Boolean)

Parameters:

• aChange: Change
• ProcessChange: Process change
• CanRemoveFromDelta: Remove change from delta

---

Fires OnGenerateSQL event.

procedure DoGenerateSQLEvent(aChangeType: TDAChangeType; const ReferencedStatement: TDAStatement; const aDelta: IDADelta; var SQL: string)

Parameters:

• aChangeType: Change type
• ReferencedStatement: Referenced statement
• aDelta: Delta
• SQL: SQL statement

---

Fires OnProcessChange

procedure DoProcessChangeEvent(aChangeType: TDAChangeType; aChange: TDADeltaChange; const aCommand: IDASQLCommand)

Parameters:

• aChangeType: Change type
• aChange: Change
• aCommand: Command

---

Fires OnProcessError

procedure DoProcessErrorEvent(aChange: TDADeltaChange; const aCommand: IDASQLCommand; var CanRemoveFromDelta: Boolean; Error: Exception)

Parameters:

• aChange: Change
• aCommand: command
• CanRemoveFromDelta: Allows removes change from delta or not
• Error: Exception raised by the data change attempt

---

Fires OnRefreshDeltaChange event.

procedure DoRefreshDeltaChangeEvent(aChangeType: TDAChangeType; aChange: TDADeltaChange; const aRefreshDataSet: IDAServerDataset)

Parameters:

• aChangeType: Change type
• aChange: Change
• aRefreshDataSet: Refresh dataset

---

Creates an IDADataset that can be used for refreshing data.

function GenerateRefreshDataset(aDataset: TDADataset; aConnection: IDAConnection; const aTargetTable: string; aColumnMappings: TDAColumnMappingCollection; AUnionMapping: TDAColumnMappingCollection): IDAServerDataset

Parameters:

• aDataset: Dataset
• aConnection: Connection
• aTargetTable: Target table
• aColumnMappings: Column mapping
• AUnionMapping: Union mapping

---

Creates an IDADataset that can be used for refreshing data.

function GenerateRefreshDataset(aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IDAConnection): IDADataset

Parameters:

• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection

---

Generates SQL for insert, update or delete according to aChangeType.

function GenerateSQL(aChangeType: TDAChangeType; aChange: TDADeltaChange; aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IDAConnection): string

Parameters:

• aChangeType: Change type
• aChange: Change
• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection

---

Generates SQL for insert, update or delete according to aChangeType.

function GenerateSQL2(aChangeType: TDAChangeType; aChange: TDADeltaChange; aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IDAConnection; aUseAutoIncUpdate: Boolean): string

Parameters:

• aChangeType: Change type
• aChange: Change
• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection
• aUseAutoIncUpdate: Use Autoinc update

---

Returns connection for specified object

function GetConnectionForObject(const aConnection: IDAConnection; const aName: string): IDAConnection

Parameters:

• aConnection: Default connection
• aName: name of object

---

Checks if reduced delta is used

property HasReducedDelta: Boolean read

---

This command will be used to apply INSERT changes for the data table back to the server. This property only needs to be assigned if your schema provides a special command for processing INSERT changes (which could be an SQL INSERT statement or a stored procedure). To make the Business Processor use this command, remove poAutoGenerateInsert in the ProcessorOptions; if poAutoGenerateInsert is specified, the Business Processor will automatically generate the necessary SQL code to perform the INSERT on the database.

property InsertCommandName: string read write

---

Forwards notification messages to all owned components.

procedure Notification(AComponent: TComponent; Operation: TOperation)

Parameters:

• AComponent: component
• Operation: operation

---

Fires right after a command was executed.

property OnAfterExecuteCommand: TDAAfterExecuteCommandEvent read write
delegate:  procedure OnAfterExecuteCommand(const Sender: IDASQLCommand; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires just after the Business Processor finishes processing an individual change received from the client.

property OnAfterProcessChange: TDAAfterProcessChangeEvent read write
delegate:  procedure OnAfterProcessChange(Sender: TDABusinessProcessor; aChange: TDADeltaChange; Processed: Boolean; var CanRemoveFromDelta: Boolean)

---

Fires right after the business processor is finished processing a delta received from the client. You can use this event to inspect (or modify) any resulting delta that was generated and will be sent back to the client.

property OnAfterProcessDelta: TDAProcessDeltaEvent read write
delegate:  procedure OnAfterProcessDelta(Sender: TDABusinessProcessor; const aDelta: IDADelta)

---

Fires just before a command will be executed.

property OnBeforeExecuteCommand: TDABeforeExecuteCommandEvent read write
delegate:  procedure OnBeforeExecuteCommand(const Sender: IDASQLCommand)

---

Fires just before the Business Processor starts processing an individual change received from the client. Use this event to inspect or make modifications to the change before it will be applied, or to prevent the change from being applied at all by setting the ProcessChange parameter to false.

property OnBeforeProcessChange: TDABeforeProcessChangeEvent read write
delegate:  procedure OnBeforeProcessChange(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; var ProcessChange: Boolean)

---

Fires just before the business processor starts processing a delta received from the client.

property OnBeforeProcessDelta: TDAProcessDeltaEvent read write
delegate:  procedure OnBeforeProcessDelta(Sender: TDABusinessProcessor; const aDelta: IDADelta)

---

Fires after the Business Processor has generated code for applying an update. You can use the SQL parameter passed to this event to inspect, log or even modify the SQL before it will be applied. Note that this event will not fire for every individual change that is being processed; for each round of updates, the Business Processor will only generate each type of SQL statement (INSERT, UPDATE, DELETE and refresh SELECT) once. Therefore, you should not use this event to make change-specific modifications to the SQL code.

property OnGenerateSQL: TDAGenerateSQLEvent read write
delegate:  procedure OnGenerateSQL(Sender: TDABusinessProcessor; ChangeType: TDAChangeType; const ReferencedStatement: TDAStatement; const aDelta: IDADelta; var SQL: string)

---

Fires as the Business Processor processes an individual change. Use this event to inspect or log the change being processed, including the actual command and it's parameters that will be run on the dataset. You can also use this event to make last adjustments to the command or its parameters, if needed, but modifications to the change itself will have no effect, as the command has already been fully initialized.

property OnProcessChange: TDAProcessChangeEvent read write
delegate:  procedure OnProcessChange(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; const aCommand: IDASQLCommand)

---

Fires if an error occurred while applying an individual change to the back-end database.

property OnProcessError: TDAProcessErrorEvent read write
delegate:  procedure OnProcessError(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; const aCommand: IDASQLCommand; var CanRemoveFromDelta: Boolean; Error: Exception)

---

Fires as the business processor executes the data refresh for an individual change. Use this event to inspect or log the refresh, including the actual SQL and dataset parameters . You can also use this event to make last adjustments to the dataset SQL or its parameters.

property OnRefreshDeltaChange: TDARefreshDeltaChangeEvent read write
delegate:  procedure OnRefreshDeltaChange(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; const aRefreshDataSet: IDADataset)

---

Performs the processing of the passed delta and applies the changes to the database.

procedure ProcessDelta(const aConnection: IDAConnection; const aDelta: IDADelta; ChangeTypes: TDAChangeTypes; ADeltaStruct: TDADeltaStruct)

Parameters:

• aConnection: Connection
• aDelta: Delta
• ChangeTypes: Change types
• ADeltaStruct: Delta struct

---

Performs the processing of the passed delta and applies the changes to the database.

procedure ProcessDeltaForUnion(const aConnection: IDAConnection; const aDelta: IDADelta; ChangeTypes: TDAChangeTypes; ADeltaStruct: TDADeltaStruct)

Parameters:

• aConnection: Connection
• aDelta: Delta
• ChangeTypes: Change types
• ADeltaStruct: Delta struct

---

Configures various options for the behavior of the business processor. Available options include:

• Generate automatic INSERT statements instead of using the InsertCommandName.
• Generate automatic UPDATE statements instead of using the UpdateCommandName.
• Generate automatic DELETE statements instead of using the DeleteCommandName.
• Generate automatic SELECT statements instead of using the RefreshDatasetName.
• Prepare commands against the back-end database for faster execution. See IDASQLCommand.Prepared for details.
• Disable the "no rows were affected by this update" error message.

property ProcessorOptions: TDAProcessorOptions read write

---

Returns a reference to a specified interface if the object supports that interface. This is one of the methods introduced by the IUnknown interface.

function QueryInterface(const IID: TGUID; out Obj: ): HResult

Parameters:

• IID: Identifier of the interface to return
• Obj: Variable to store the returned interface reference to

---

Manages how TDABusinessProcessor behaves when an error is encountered.

property RaiseExceptionAtError: Boolean read write

---

The dataset (data table) to which this Business Processor refers. Every Business Processor is configured to handle deltas for one specific data table, and this property will be used to determine which table is handled by this processor.

property ReferencedDataset: string read write

---

Sets the name of the datatset (data table) that will be used to fetch refresh data from the server. This property only needs to be assigned if your schema provides a special dataset for refreshing data from the server (which could be an SQL SELECT statement or a stored procedure). To make the Business Processor use this dataset, remove poAutoGenerateRefreshDataset in the ProcessorOptions; if poAutoGenerateRefreshDataset is specified, the Business Processor will automatically generate the necessary SQL code to perform the SELECT on the database.

property RefreshDatasetName: string read write

---

Forwards notification messages to all owned components.

procedure ROFreeNotification(aComponent: TComponent)

Parameters:

• aComponent: component

---

Forwards notification messages to all owned components.

procedure RORemoveFreeNotification(aComponent: TComponent)

Parameters:

• aComponent: component

---

References the TDASchema that the Business Processor will be working on. Most commonly, this is the ServiceSchema of the data service. All the data tables and commands referenced from InsertCommandName, UpdateCommandName, DeleteCommandName, RefreshDatasetName and ReferencedDataset must be defined in this schema.

property Schema: TDASchema read write

---

Component which performs the execution of the script.

property ScriptingProvider: TDABaseScriptingProvider read write

---

Forwards notification messages to all owned components.

procedure SendRemoveNotification(aComponent: TComponent)

Parameters:

• aComponent: component

---

Reference to own service.

property Service: TRORemoteDataModule read write

---

Creates delta commands

procedure SetupCommands(const aConnection: IDAConnection; const aChange: TDADeltaChange; out anCmd: IDASQLCommand; out aTargetTable: string; aUseAutoIncUpdate: Boolean)

Parameters:

• aConnection: Connection
• aChange: Change
• anCmd: Command
• aTargetTable: Target table
• aUseAutoIncUpdate: Use Autoinc update

---

Creates delta commands

procedure SetupCommands(const aConnection: IDAConnection; const aDelta: IDADelta; out aCommandsList: TDADeltaProcessorItemCollection)

Parameters:

• aConnection: Connection
• aDelta: Delta
• aCommandsList: List of commands

---

Creates delta commands

procedure SetupCommands(const aConnection: IDAConnection; const aDelta: IDADelta; out anInsertCmd: IDASQLCommand; out anUpdateCmd: IDASQLCommand; out anUpdateCMD_AutoInc: IDASQLCommand; out aDeleteCmd: IDASQLCommand; out aRefreshDs: IDAServerDataset; out aTargetTable: string)

Parameters:

• aConnection: Connection
• aDelta: Delta
• anInsertCmd: Insert command
• anUpdateCmd: Update command
• anUpdateCMD_AutoInc: Insert command for autoinc
• aDeleteCmd: Delete command
• aRefreshDs: Refresh dataset
• aTargetTable: Target table

---

Creates delta command

procedure SetupCommandsWithMapping(const aConnection: IDAConnection; const aChange: TDADeltaChange; const aChangeType: TDAChangeType; out anCmd: IDASQLCommand; out aParamMapping: TDAParamMappingArray; out aRefreshDs: IDAServerDataset; out aTargetTable: string; aUseAutoIncUpdate: Boolean)

Parameters:

• aConnection: Connection
• aChange: Change
• aChangeType: Change type
• anCmd: Command
• aParamMapping: Param mapping
• aRefreshDs: Refresh dataset
• aTargetTable: Target table
• aUseAutoIncUpdate: Use Autoinc update

---

Setups delta commands

procedure SetupDeltaCommands(ADatasetName: string; AOverride: Boolean)

Parameters:

• ADatasetName: Dataset name
• AOverride: Allows to use delta commands as they are declared in schema

---

Synchonizes auto increment values between master and detail deltas

procedure SynchronizeAutoIncs(const aMasterDelta: IDADelta; const aDetailDelta: IDADelta; const aRelationship: TDADatasetRelationship)

Parameters:

• aMasterDelta: master delta
• aDetailDelta: detail delta
• aRelationship: relationship

---

This command will be used to apply UPDATE changes for the data table back to the server. This property only needs to be assigned if your schema provides a special command for processing UPDATE changes (which could be an SQL UPDATE statement or a stored procedure). To make the Business Processor use this command, remove poAutoGenerateUpdate in the ProcessorOptions; if poAutoGenerateUpdate is specified, the Business Processor will automatically generate the necessary SQL code to perform the UPDATE on the database.

property UpdateCommandName: string read write

---

Defines how rows for UPDATEs and DELETEs will be located. Available options are:

• Only the fields from the primary key (PK) of the data table will be used to locate records for UPDATEs and DELETEs.
• All fields defined for the data table will be used to locate records for UPDATEs and DELETEs.
• The fields from the primary key (PK) of the data table plus those listed in the business processor's UserUpdateFields property will be used to locate records for UPDATEs and DELETEs.
• Only the fields listed in the business processor's UserUpdateFields property will be used to locate records for UPDATEs and DELETEs.

property UpdateMode: TDAUpdateMode read write

---

Updates SQL that was received with GenerateSQL with Oracle specific syntax.

procedure UpdateSQLForOracle(aChangeType: TDAChangeType; aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IOracleConnection; var OriginalSQL: string)

Parameters:

• aChangeType: Change type
• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection
• OriginalSQL: Original SQL

---

Contains the list of fields to be used to locate rows for updating and deleting, if the UpdateMode is set to updWhereKeyAndUserDefined or updWhereUserDefined.

property UserUpdateFields: TStrings read write

 

Used for associating current strongly typed business processor to a business helper class . It should correspond to a value used in RegisterBusinessProcessorRules method, called in initialization section of the business helper class unit.

property BusinessRulesID: string read write

---

This is an individual changed record currently being processed.

property CurrentChange: TDADeltaChange read

---

CurrentDelta is the set of changes currently to be transmitted between client and server.

property CurrentDelta: TDADelta read

---

This command will be used to apply DELETE changes for the data table back to the server. This property only needs to be assigned if your schema provides a special command for processing DELETE changes (which could be an SQL DELETE statement or a stored procedure). To make the Business Processor use this command, remove poAutoGenerateDelete in the ProcessorOptions; if poAutoGenerateDelete is specified, the Business Processor will automatically generate the necessary SQL code to perform the DELETE on the database.

property DeleteCommandName: string read write

---

Checks if reduced delta is used

property HasReducedDelta: Boolean read

---

This command will be used to apply INSERT changes for the data table back to the server. This property only needs to be assigned if your schema provides a special command for processing INSERT changes (which could be an SQL INSERT statement or a stored procedure). To make the Business Processor use this command, remove poAutoGenerateInsert in the ProcessorOptions; if poAutoGenerateInsert is specified, the Business Processor will automatically generate the necessary SQL code to perform the INSERT on the database.

property InsertCommandName: string read write

---

Configures various options for the behavior of the business processor. Available options include:

• Generate automatic INSERT statements instead of using the InsertCommandName.
• Generate automatic UPDATE statements instead of using the UpdateCommandName.
• Generate automatic DELETE statements instead of using the DeleteCommandName.
• Generate automatic SELECT statements instead of using the RefreshDatasetName.
• Prepare commands against the back-end database for faster execution. See IDASQLCommand.Prepared for details.
• Disable the "no rows were affected by this update" error message.

property ProcessorOptions: TDAProcessorOptions read write

---

Manages how TDABusinessProcessor behaves when an error is encountered.

property RaiseExceptionAtError: Boolean read write

---

The dataset (data table) to which this Business Processor refers. Every Business Processor is configured to handle deltas for one specific data table, and this property will be used to determine which table is handled by this processor.

property ReferencedDataset: string read write

---

Sets the name of the datatset (data table) that will be used to fetch refresh data from the server. This property only needs to be assigned if your schema provides a special dataset for refreshing data from the server (which could be an SQL SELECT statement or a stored procedure). To make the Business Processor use this dataset, remove poAutoGenerateRefreshDataset in the ProcessorOptions; if poAutoGenerateRefreshDataset is specified, the Business Processor will automatically generate the necessary SQL code to perform the SELECT on the database.

property RefreshDatasetName: string read write

---

References the TDASchema that the Business Processor will be working on. Most commonly, this is the ServiceSchema of the data service. All the data tables and commands referenced from InsertCommandName, UpdateCommandName, DeleteCommandName, RefreshDatasetName and ReferencedDataset must be defined in this schema.

property Schema: TDASchema read write

---

Component which performs the execution of the script.

property ScriptingProvider: TDABaseScriptingProvider read write

---

Reference to own service.

property Service: TRORemoteDataModule read write

---

This command will be used to apply UPDATE changes for the data table back to the server. This property only needs to be assigned if your schema provides a special command for processing UPDATE changes (which could be an SQL UPDATE statement or a stored procedure). To make the Business Processor use this command, remove poAutoGenerateUpdate in the ProcessorOptions; if poAutoGenerateUpdate is specified, the Business Processor will automatically generate the necessary SQL code to perform the UPDATE on the database.

property UpdateCommandName: string read write

---

Defines how rows for UPDATEs and DELETEs will be located. Available options are:

• Only the fields from the primary key (PK) of the data table will be used to locate records for UPDATEs and DELETEs.
• All fields defined for the data table will be used to locate records for UPDATEs and DELETEs.
• The fields from the primary key (PK) of the data table plus those listed in the business processor's UserUpdateFields property will be used to locate records for UPDATEs and DELETEs.
• Only the fields listed in the business processor's UserUpdateFields property will be used to locate records for UPDATEs and DELETEs.

property UpdateMode: TDAUpdateMode read write

---

Contains the list of fields to be used to locate rows for updating and deleting, if the UpdateMode is set to updWhereKeyAndUserDefined or updWhereUserDefined.

property UserUpdateFields: TStrings read write

 

Standard component constructor

constructor Create(aOwner: TComponent)

Parameters:

• aOwner: Owner

---

Copies the contents of another, similar object.

procedure Assign(Source: TPersistent)

Parameters:

• Source: Instance whose properties will be copied

---

Validates the business processor properties.

procedure CheckProperties

---

Creates mapping for specific command

procedure CreateMappings(const aDelta: IDADelta; out MappingArray: TDAParamMappingArray; const aCommand: IDASQLCommand; lAdditionalMapping: TDAColumnMappingCollection; AValidateCommand: Boolean)

Parameters:

• aDelta: Delta
• MappingArray: Mapping array
• aCommand: Command
• lAdditionalMapping: Additional mapping
• AValidateCommand: Validate command

---

Fires AfterExecuteCommand event.

procedure DoAfterExecuteCommandEvent(const ACommand: IDASQLCommand; CommandName: string; ElapsedMilliseconds: Cardinal)

Parameters:

• ACommand: command
• CommandName: command name
• ElapsedMilliseconds: time of execution of command

---

Fires AfterProcessChange event.

procedure DoAfterProcessChangeEvent(aChange: TDADeltaChange; Processed: Boolean; var CanRemoveFromDelta: Boolean)

Parameters:

• aChange: Change
• Processed: Status of change
• CanRemoveFromDelta: Remove change from delta or not.

---

Fires OnAfterProcessDelta

procedure DoAfterProcessDeltaEvent(const aDelta: IDADelta)

Parameters:

• aDelta: Delta

---

Fires BeforeExecuteCommand event.

procedure DoBeforeExecuteCommandEvent(const ACommand: IDASQLCommand; CommandName: string)

Parameters:

• ACommand: Command
• CommandName: Command name

---

Fires OnBeforeProcessChange

procedure DoBeforeProcessChangeEvent(aChange: TDADeltaChange; var ProcessChange: Boolean; var CanRemoveFromDelta: Boolean)

Parameters:

• aChange: Change
• ProcessChange: Process change
• CanRemoveFromDelta: Remove change from delta

---

Fires OnGenerateSQL event.

procedure DoGenerateSQLEvent(aChangeType: TDAChangeType; const ReferencedStatement: TDAStatement; const aDelta: IDADelta; var SQL: string)

Parameters:

• aChangeType: Change type
• ReferencedStatement: Referenced statement
• aDelta: Delta
• SQL: SQL statement

---

Fires OnProcessChange

procedure DoProcessChangeEvent(aChangeType: TDAChangeType; aChange: TDADeltaChange; const aCommand: IDASQLCommand)

Parameters:

• aChangeType: Change type
• aChange: Change
• aCommand: Command

---

Fires OnProcessError

procedure DoProcessErrorEvent(aChange: TDADeltaChange; const aCommand: IDASQLCommand; var CanRemoveFromDelta: Boolean; Error: Exception)

Parameters:

• aChange: Change
• aCommand: command
• CanRemoveFromDelta: Allows removes change from delta or not
• Error: Exception raised by the data change attempt

---

Fires OnRefreshDeltaChange event.

procedure DoRefreshDeltaChangeEvent(aChangeType: TDAChangeType; aChange: TDADeltaChange; const aRefreshDataSet: IDAServerDataset)

Parameters:

• aChangeType: Change type
• aChange: Change
• aRefreshDataSet: Refresh dataset

---

Creates an IDADataset that can be used for refreshing data.

function GenerateRefreshDataset(aDataset: TDADataset; aConnection: IDAConnection; const aTargetTable: string; aColumnMappings: TDAColumnMappingCollection; AUnionMapping: TDAColumnMappingCollection): IDAServerDataset

Parameters:

• aDataset: Dataset
• aConnection: Connection
• aTargetTable: Target table
• aColumnMappings: Column mapping
• AUnionMapping: Union mapping

---

Creates an IDADataset that can be used for refreshing data.

function GenerateRefreshDataset(aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IDAConnection): IDADataset

Parameters:

• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection

---

Generates SQL for insert, update or delete according to aChangeType.

function GenerateSQL(aChangeType: TDAChangeType; aChange: TDADeltaChange; aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IDAConnection): string

Parameters:

• aChangeType: Change type
• aChange: Change
• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection

---

Generates SQL for insert, update or delete according to aChangeType.

function GenerateSQL2(aChangeType: TDAChangeType; aChange: TDADeltaChange; aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IDAConnection; aUseAutoIncUpdate: Boolean): string

Parameters:

• aChangeType: Change type
• aChange: Change
• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection
• aUseAutoIncUpdate: Use Autoinc update

---

Returns connection for specified object

function GetConnectionForObject(const aConnection: IDAConnection; const aName: string): IDAConnection

Parameters:

• aConnection: Default connection
• aName: name of object

---

Forwards notification messages to all owned components.

procedure Notification(AComponent: TComponent; Operation: TOperation)

Parameters:

• AComponent: component
• Operation: operation

---

Performs the processing of the passed delta and applies the changes to the database.

procedure ProcessDelta(const aConnection: IDAConnection; const aDelta: IDADelta; ChangeTypes: TDAChangeTypes; ADeltaStruct: TDADeltaStruct)

Parameters:

• aConnection: Connection
• aDelta: Delta
• ChangeTypes: Change types
• ADeltaStruct: Delta struct

---

Performs the processing of the passed delta and applies the changes to the database.

procedure ProcessDeltaForUnion(const aConnection: IDAConnection; const aDelta: IDADelta; ChangeTypes: TDAChangeTypes; ADeltaStruct: TDADeltaStruct)

Parameters:

• aConnection: Connection
• aDelta: Delta
• ChangeTypes: Change types
• ADeltaStruct: Delta struct

---

Returns a reference to a specified interface if the object supports that interface. This is one of the methods introduced by the IUnknown interface.

function QueryInterface(const IID: TGUID; out Obj: ): HResult

Parameters:

• IID: Identifier of the interface to return
• Obj: Variable to store the returned interface reference to

---

Forwards notification messages to all owned components.

procedure ROFreeNotification(aComponent: TComponent)

Parameters:

• aComponent: component

---

Forwards notification messages to all owned components.

procedure RORemoveFreeNotification(aComponent: TComponent)

Parameters:

• aComponent: component

---

Forwards notification messages to all owned components.

procedure SendRemoveNotification(aComponent: TComponent)

Parameters:

• aComponent: component

---

Creates delta commands

procedure SetupCommands(const aConnection: IDAConnection; const aChange: TDADeltaChange; out anCmd: IDASQLCommand; out aTargetTable: string; aUseAutoIncUpdate: Boolean)

Parameters:

• aConnection: Connection
• aChange: Change
• anCmd: Command
• aTargetTable: Target table
• aUseAutoIncUpdate: Use Autoinc update

---

Creates delta commands

procedure SetupCommands(const aConnection: IDAConnection; const aDelta: IDADelta; out aCommandsList: TDADeltaProcessorItemCollection)

Parameters:

• aConnection: Connection
• aDelta: Delta
• aCommandsList: List of commands

---

Creates delta commands

procedure SetupCommands(const aConnection: IDAConnection; const aDelta: IDADelta; out anInsertCmd: IDASQLCommand; out anUpdateCmd: IDASQLCommand; out anUpdateCMD_AutoInc: IDASQLCommand; out aDeleteCmd: IDASQLCommand; out aRefreshDs: IDAServerDataset; out aTargetTable: string)

Parameters:

• aConnection: Connection
• aDelta: Delta
• anInsertCmd: Insert command
• anUpdateCmd: Update command
• anUpdateCMD_AutoInc: Insert command for autoinc
• aDeleteCmd: Delete command
• aRefreshDs: Refresh dataset
• aTargetTable: Target table

---

Creates delta command

procedure SetupCommandsWithMapping(const aConnection: IDAConnection; const aChange: TDADeltaChange; const aChangeType: TDAChangeType; out anCmd: IDASQLCommand; out aParamMapping: TDAParamMappingArray; out aRefreshDs: IDAServerDataset; out aTargetTable: string; aUseAutoIncUpdate: Boolean)

Parameters:

• aConnection: Connection
• aChange: Change
• aChangeType: Change type
• anCmd: Command
• aParamMapping: Param mapping
• aRefreshDs: Refresh dataset
• aTargetTable: Target table
• aUseAutoIncUpdate: Use Autoinc update

---

Setups delta commands

procedure SetupDeltaCommands(ADatasetName: string; AOverride: Boolean)

Parameters:

• ADatasetName: Dataset name
• AOverride: Allows to use delta commands as they are declared in schema

---

Synchonizes auto increment values between master and detail deltas

procedure SynchronizeAutoIncs(const aMasterDelta: IDADelta; const aDetailDelta: IDADelta; const aRelationship: TDADatasetRelationship)

Parameters:

• aMasterDelta: master delta
• aDetailDelta: detail delta
• aRelationship: relationship

---

Updates SQL that was received with GenerateSQL with Oracle specific syntax.

procedure UpdateSQLForOracle(aChangeType: TDAChangeType; aDataset: TDADataset; const aDelta: IDADelta; aDatasetStatement: TDAStatement; aConnection: IOracleConnection; var OriginalSQL: string)

Parameters:

• aChangeType: Change type
• aDataset: Dataset
• aDelta: Delta
• aDatasetStatement: Dataset statement
• aConnection: Connection
• OriginalSQL: Original SQL

 

Fires right after a command was executed.

property OnAfterExecuteCommand: TDAAfterExecuteCommandEvent read write
delegate:  procedure OnAfterExecuteCommand(const Sender: IDASQLCommand; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires just after the Business Processor finishes processing an individual change received from the client.

property OnAfterProcessChange: TDAAfterProcessChangeEvent read write
delegate:  procedure OnAfterProcessChange(Sender: TDABusinessProcessor; aChange: TDADeltaChange; Processed: Boolean; var CanRemoveFromDelta: Boolean)

---

Fires right after the business processor is finished processing a delta received from the client. You can use this event to inspect (or modify) any resulting delta that was generated and will be sent back to the client.

property OnAfterProcessDelta: TDAProcessDeltaEvent read write
delegate:  procedure OnAfterProcessDelta(Sender: TDABusinessProcessor; const aDelta: IDADelta)

---

Fires just before a command will be executed.

property OnBeforeExecuteCommand: TDABeforeExecuteCommandEvent read write
delegate:  procedure OnBeforeExecuteCommand(const Sender: IDASQLCommand)

---

Fires just before the Business Processor starts processing an individual change received from the client. Use this event to inspect or make modifications to the change before it will be applied, or to prevent the change from being applied at all by setting the ProcessChange parameter to false.

property OnBeforeProcessChange: TDABeforeProcessChangeEvent read write
delegate:  procedure OnBeforeProcessChange(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; var ProcessChange: Boolean)

---

Fires just before the business processor starts processing a delta received from the client.

property OnBeforeProcessDelta: TDAProcessDeltaEvent read write
delegate:  procedure OnBeforeProcessDelta(Sender: TDABusinessProcessor; const aDelta: IDADelta)

---

Fires after the Business Processor has generated code for applying an update. You can use the SQL parameter passed to this event to inspect, log or even modify the SQL before it will be applied. Note that this event will not fire for every individual change that is being processed; for each round of updates, the Business Processor will only generate each type of SQL statement (INSERT, UPDATE, DELETE and refresh SELECT) once. Therefore, you should not use this event to make change-specific modifications to the SQL code.

property OnGenerateSQL: TDAGenerateSQLEvent read write
delegate:  procedure OnGenerateSQL(Sender: TDABusinessProcessor; ChangeType: TDAChangeType; const ReferencedStatement: TDAStatement; const aDelta: IDADelta; var SQL: string)

---

Fires as the Business Processor processes an individual change. Use this event to inspect or log the change being processed, including the actual command and it's parameters that will be run on the dataset. You can also use this event to make last adjustments to the command or its parameters, if needed, but modifications to the change itself will have no effect, as the command has already been fully initialized.

property OnProcessChange: TDAProcessChangeEvent read write
delegate:  procedure OnProcessChange(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; const aCommand: IDASQLCommand)

---

Fires if an error occurred while applying an individual change to the back-end database.

property OnProcessError: TDAProcessErrorEvent read write
delegate:  procedure OnProcessError(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; const aCommand: IDASQLCommand; var CanRemoveFromDelta: Boolean; Error: Exception)

---

Fires as the business processor executes the data refresh for an individual change. Use this event to inspect or log the refresh, including the actual SQL and dataset parameters . You can also use this event to make last adjustments to the dataset SQL or its parameters.

property OnRefreshDeltaChange: TDARefreshDeltaChangeEvent read write
delegate:  procedure OnRefreshDeltaChange(Sender: TDABusinessProcessor; aChangeType: TDAChangeType; aChange: TDADeltaChange; const aRefreshDataSet: IDADataset)