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, UnicodeString, string, Boolean, Boolean, TDAColumnMappingCollection, Boolean, TDAOrderByCollection, Integer, string, Boolean): IDADataset  overload

Creates a new dataset

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

Parameters:

  • aConnection: Connection
  • aName: Dataset name
  • aDynSelectFields: Fields for Dynamic Select feature
  • aWhereClause: Dynamic Where expression
  • aStatementName: Statement name
  • OpenIt: Open created dataset
  • AlwaysGenerateDynamicWhereStatement: Generate {WHERE} macro
  • anUnionMapping: Union mapping
  • AllowAllFieldsInDynamicWhere: Allows to use all fields in Dynamic Where expression.
  • aOrderBy: Dynamic Order collection
  • aMaxRecords: Specifies the maximum number of records. A value of -1 (default) will retrieve all records
  • aConnectionType: Connection type
  • aServerSideAccess: Allows access to private tables/fields

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, UnicodeString, Boolean, string, Boolean, TDAOrderByCollection, Integer, 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; aDynSelectFields: array of string; aWhereClause: UnicodeString; OpenIt: Boolean; aStatementName: string; AllowAllFieldsInDynamicWhere: Boolean; aOrderBy: TDAOrderByCollection; aMaxRecords: Integer; aConnectionType: string; aServerSideAccess: Boolean): IDADataset

Parameters:

  • aConnection: Connection
  • aName: Dataset name
  • ParamNames: Parameter names
  • ParamValues: Parameter values
  • aDynSelectFields: Fields for Dynamic Select feature
  • aWhereClause: Dynamic Where expression
  • OpenIt: Open created dataset
  • aStatementName: Statement name
  • AllowAllFieldsInDynamicWhere: Allows to use all fields in Dynamic Where expression.
  • aOrderBy: Dynamic Order collection
  • aMaxRecords: Specifies the maximum number of records. A value of -1 (default) will retrieve all records
  • aConnectionType: Connection type
  • aServerSideAccess: Allows access to private tables/fields

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