IDASQLGenerator

Overview

IDASQLGenerator provides access to TDABusinessProcessor methods from Hydra and other plugins.

Location

Implemented in

Required Methods


GenerateRefreshDataset

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

GenerateSQL

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

UpdateSQLForOracle

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