IDASchema

Overview

The IDASchema interface represents functions to work with commands and datasets in a custom Schema.

The TDASchema class, for example, implements the IDASchema interface to work with specified Schema commands and datasets.

Location

  • Unit: uDAServerInterfaces.pas
  • Ancestry: IDASchema


Required Methods

Clear

Clears the datasets and command s that are related to the current schema.

procedure Clear

GetCommandText

Returns the SQL statement for the specified command with the name aName.

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

Parameters:

  • aConnection: Specified connection
  • aName: Name of the specified command

GetDatasetText

Returns the SQL statement for the specified dataset with the name aName.

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

Parameters:

  • aConnection: Specified connection
  • aName: Name of the specified dataset

MergeDataDictionaries

Returns true if the current dataset contains the related data dictionaries, otherwise returns false.

function MergeDataDictionaries: Boolean

NewCommand (IDAConnection, string, string, string): IDASQLCommand  overload

Creates a new command

function NewCommand(const aConnection: IDAConnection; const aName: string; aStatementName: string; aConnectionType: string): IDASQLCommand

Parameters:

  • aConnection: Specified connection
  • aName: Specified command name
  • aStatementName: SQL statement that is associated with the new command
  • aConnectionType: connection type.

NewCommand (IDAConnection, string, array of string, array of Variant, Boolean, string, string): IDASQLCommand  overload

Creates a new command

function NewCommand(const aConnection: IDAConnection; const aName: string; const ParamNames: array of string; const ParamValues: array of Variant; ExecuteIt: Boolean; aStatementName: string; aConnectionType: string): IDASQLCommand

Parameters:

  • aConnection: Specified connection
  • aName: Specified command name
  • ParamNames: parameter names
  • ParamValues: parameter values
  • ExecuteIt: executes created command
  • aStatementName: SQL statement that is associated with the new command
  • aConnectionType: connection type.

NewDataset (IDAConnection, string, array of string, TDAWhereExpression, string, Boolean, Boolean, TDAColumnMappingCollection, Boolean, TDAOrderByCollection, Integer, string, Boolean): IDADataset  overload

function NewDataset(const aConnection: IDAConnection; const aName: string; aDynSelectFields: array of string; aWhereExpression: TDAWhereExpression; aStatementName: string; OpenIt: Boolean; AlwaysGenerateDynamicWhereStatement: Boolean; anUnionMapping: TDAColumnMappingCollection; AllowAllFieldsInDynamicWhere: Boolean; aOrderBy: TDAOrderByCollection; aMaxRecords: Integer; aConnectionType: string; aServerSideAccess: Boolean): IDADataset

Parameters:

  • aConnection:
  • aName:
  • aDynSelectFields:
  • aWhereExpression:
  • aStatementName:
  • OpenIt:
  • AlwaysGenerateDynamicWhereStatement:
  • anUnionMapping:
  • AllowAllFieldsInDynamicWhere:
  • aOrderBy:
  • aMaxRecords:
  • aConnectionType:
  • aServerSideAccess:

NewDataset (IDAConnection, string, string, Boolean, string, Boolean): IDADataset  overload

Creates a new dataset

function NewDataset(const aConnection: IDAConnection; const aName: string; aStatementName: string; OpenIt: Boolean; aConnectionType: string; aServerSideAccess: Boolean): IDADataset

Parameters:

  • aConnection: Connection
  • aName: Dataset name
  • aStatementName: Statement name
  • OpenIt: Open created dataset
  • aConnectionType: Connection type
  • aServerSideAccess: Allows access to private tables/fields

NewDataset (IDAConnection, string, array of string, array of Variant, array of string, TDAWhereExpression, Boolean, string, Boolean, TDAOrderByCollection, Integer, string, Boolean): IDADataset  overload

function NewDataset(const aConnection: IDAConnection; const aName: string; const ParamNames: array of string; const ParamValues: array of Variant; aDynSelectFields: array of string; aWhereExpression: TDAWhereExpression; OpenIt: Boolean; aStatementName: string; AllowAllFieldsInDynamicWhere: Boolean; aOrderBy: TDAOrderByCollection; aMaxRecords: Integer; aConnectionType: string; aServerSideAccess: Boolean): IDADataset

Parameters:

  • aConnection:
  • aName:
  • ParamNames:
  • ParamValues:
  • aDynSelectFields:
  • aWhereExpression:
  • OpenIt:
  • aStatementName:
  • AllowAllFieldsInDynamicWhere:
  • aOrderBy:
  • aMaxRecords:
  • aConnectionType:
  • aServerSideAccess:

NewDataset (IDAConnection, string, array of string, array of Variant, Boolean, string, string, Boolean): IDADataset  overload

Creates a new dataset

function NewDataset(const aConnection: IDAConnection; const aName: string; const ParamNames: array of string; const ParamValues: array of Variant; OpenIt: Boolean; aStatementName: string; aConnectionType: string; aServerSideAccess: Boolean): IDADataset

Parameters:

  • aConnection: Connection
  • aName: Dataset name
  • ParamNames: Parameter names
  • ParamValues: Parameter values
  • OpenIt: Open created dataset
  • aStatementName: Statement name
  • aConnectionType: Connection type
  • aServerSideAccess: Allows access to private tables/fields