IDASQLGenerator

Overview

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

Location


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