TDAEDataset

 

Creates a new instance.

constructor Create(aConnection: IDAConnection; aDataset: TDataset; const aName: string)

Parameters:

• aConnection: Connection
• aDataset: Dataset
• aName: Name

---

Creates a new instance.

constructor Create(aConnection: TDAEConnection; const aName: string)

Parameters:

• aConnection:
• aName:

---

Specifies whether the dataset is currently active (open) or not. Setting this property to true will automatically open the dataset, while setting it to false will automatically close it.

property Active: Boolean read write

---

property CachedParams: TDictionary<string, Integer> read

---

Specifies that given field can return data in GetNativeFieldData method

function CanUseNativeFieldData(Index: Integer): Boolean

Parameters:

• Index: Required field index

---

Indicates that SQL was changed and PrepareSQLStatement should be called

property Changed: Boolean read write

---

Clears parameter values.

procedure ClearParams

---

Closes the dataset

procedure Close

---

Presents the IDAConnection to access information about available databases, tables, columns, etc.

property Connection: IDAConnection read

---

Connection

property Connection: TDAEConnection read

---

Indicates whether data-aware controls update their display to reflect changes to the dataset.

function ControlsDisabled: Boolean

---

Creates native dataset object

function CreateDataset(aConnection: TDAEConnection): TDataset

Parameters:

• aConnection: owner connection

---

Creates an IDANativeDatabaseAccess implementor.

function CreateNativeDatabaseAccess: IDANativeDatabaseAccess

---

Creates the native object.

function CreateNativeObject(aConnection: TDAEConnection): TObject

Parameters:

• aConnection: connection

---

not supported

property CurrentRecIdValue: Integer read write

---

Access to the standard VCL TDataSet.

property Dataset: TDataset read

---

Disables dataset constraints

procedure DisableConstraints

---

Disables data display in data-aware controls associated with the dataset.

procedure DisableControls

---

Creates a object specific to the given connection.

function DoCreateNativeObject: TObject

---

Executes SQL statement

function DoExecute: Integer

---

Returns current state

function DoGetActive: Boolean

---

Indicates whether reading the dataset has reached the beginning of the recordset (BOF = Beginning of File). GetBOF will only turn true if neither an empty dataset was opened nor Prior was called while the cursor was on the first record (it will not turn to true automatically when reaching the first record).

function DoGetBOF: Boolean

---

Indicates whether reading the dataset has reached the end of the recordset (EOF = End of File). EOF will only turn true if neither an empty dataset was opened or Next was called while the cursor was already on the last record (it will not turn to true when reaching the last record).

function DoGetEOF: Boolean

---

Returns the counf of records

function DoGetRecordCount: Integer

---

Gets the SQL statement

function DoGetSQL: string

---

Locates and activates a record by key values.

function DoLocate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean

Parameters:

• KeyFields: The semicolon-separated list of fields.
• KeyValues: Values specified by the Variant or Variant array.
• Options: Indicates whether the search is case insensitive and whether partial matches are supported.

---

Returns the result of the NativeDatabaseAccess.Next invocation. Please refer to the article How to create a Data Abstract Driver (Delphi) for more details.

procedure DoNext

---

Sets the property Prepared of the referred dataset to AValue.

procedure DoPrepare(Value: Boolean)

Parameters:

• Value: state

---

Activates (True) or deactivates (False) the dataset. If the Value is true, the MacroProcessor of the active connection processes the Dynamic Where, retrieves and sets up the query parameters, activates the underlaid dataset (NativeDatabaseAccess) and binds the fields. If the Value is false, the underlaid dataset (NativeDatabaseAccess) is deactivated and the fields are unbound or cleared. Please refer to the article How to create a Data Abstract Driver (Delphi) for more details.

procedure DoSetActive(Value: Boolean)

Parameters:

• Value: mode

---

Sets the SQL statement

procedure DoSetSQL(const Value: string)

Parameters:

• Value: SQL statement

---

Implementation of Dynamic Where.

property DynamicWhere: TDAWhereBuilder read write

---

Enables dataset constraints

procedure EnableConstraints

---

Enables data display in data-aware controls associated with the dataset.

procedure EnableControls

---

Indicates whether reading the dataset has reached the end of the recordset (EOF = End of File). EOF will only turn true if neither an empty dataset was opened or Next was called while the cursor was already on the last record (it will not turn to true when reaching the last record).

property Eof: Boolean read

---

Executes the SQL command.

function Execute: Integer

---

Finds a field based on its name. If the specified field does not exist, FieldByName raises an exception.

function FieldByName(const aName: string): TDAField

Parameters:

• aName: name of the searched field

---

Indicates the number of fields contained in the dataset.

property FieldCount: Integer read

---

Provides access to all the fields contained in the dataset.

property Fields: TDAFieldCollection read

---

Provides convenient access to all the fields values of the current record without having to go though the Fields collection property.

property FieldValues[Index: Integer]: Variant read

---

function FindCachedParameter(const AParams: TParams; const AParamName: string): TParam

Parameters:

• AParams:
• AParamName:

---

Returns an item with the specified name.

function FindField(const aName: string): TDAField

Parameters:

• aName: name of the searched field

---

Finds the AParamName parameter in the |TParams collection.

function FindParameter(const AParams: TParams; const AParamName: string): TParam

Parameters:

• AParams:
• AParamName:

---

Corrects a known issue with parameters that have ftFMTBcd type.

procedure FixFMTBCDIssue

---

Fixes known problems. at this moment, it can call FixFMTBCDIssue if it is required

procedure FixKnownIssues

---

Frees the resources allocated for a specified bookmark.

procedure FreeBookmark(Bookmark: TBookmark)

Parameters:

• Bookmark: bookmark that should be freed

---

Returns the result of the DoGetActive invocation.

function GetActive: Boolean

---

Indicates whether reading the dataset has reached the beginning of the recordset (BOF = Beginning of File). GetBOF will only turn true if neither an empty dataset was opened nor Prior was called while the cursor was on the first record (it will not turn to true automatically when reaching the first record).

function GetBOF: Boolean

---

Allocates a bookmark for the active record

function GetBookMark: Pointer

---

Returns instance of used macro processor.

function GetCurrentMacroProcessor: TDASQLMacroProcessor

---

Implements IDASQLCommand by returning the result of CreateDataset.

function GetDataset: TDataset

---

Returns value of data table's field specified by index

function GetFieldValues(Index: Integer): Variant

Parameters:

• Index: index of the field

---

Implements IDASQLCommand by returning a value set in the constructor.

function GetName: string

---

Sets the DataSize to the according field size value, allocates the Data memory and copies the content of the field.

function GetNativeFieldData(Index: Integer; var Buffer: TBytes): Boolean

Parameters:

• Index: Required field index
• Buffer:

---

Returns the field type of the Index field

function GetNativeFieldDataType(Index: Integer): TFieldType

Parameters:

• Index: field index

---

Implements IDASQLCommand by returning the current parameters.

function GetParams: TDAParamCollection

---

Retrieves the values of the given parameters.

procedure GetParamValues(Params: TDAParamCollection)

Parameters:

• Params: Parameters

---

Retrieves the values from Params2 for the daptOutput, daptInputOutput and daptResult parameters of Params1.

procedure GetParamValuesStd(Params1: TDAParamCollection; Params2: TParams)

Parameters:

• Params1: Parameters guide
• Params2: Values source

---

function GetRowRecIDValue: Integer

---

Positions on the record to which a specified bookmark points.

procedure GotoBookmark(Bookmark: TBookmark)

Parameters:

• Bookmark: record identified by this Bookmark should be active

---

Gets mapping |TFieldType to TDADataType.

function intVCLTypeToDAType(aFieldType: TFieldType; ASize: Integer; ADecimalPrecision: Integer; aDecimalScale: Integer): TDADataType

Parameters:

• aFieldType:
• ASize:
• ADecimalPrecision:
• aDecimalScale:

---

Indicates the special mode in which (0=1) where statement is added to Dynamic Where.

function isConnectioninRefreshFieldsMode: Boolean

---

Indicates whether the dataset contains no records.

property IsEmpty: Boolean read

---

This is a virtual method (instrumental interface) to correct possible incompatibilities of the concrete implementation of the dataset (the known issue with the ZEOS driver). Please refer to the article How to create a Data Abstract Driver (Delphi) for more details.

function IsNeedToFixFMTBCDIssue: Boolean

---

Returns true if data access object is TDataset descendant.

function IsTDatasetCompatible: Boolean

---

Locates and activates a record by key values.

function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean

Parameters:

• KeyFields: The semicolon-separated list of fields.
• KeyValues: Values specified by the Variant or Variant array.
• Options: Indicates whether the search is case insensitive and whether partial matches are supported.

---

Defines the name of the data table.

property LogicalName: string read write

---

Returns the result of the NativeDatabaseAccess.Lookup invocation.

function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant

Parameters:

• KeyFields: Comma-delimited list of fields
• KeyValues: Variant or Variant array of values
• ResultFields: Comma-delimited list of fields

---

Returns a human-readable name for the command.

property Name: string read

---

Returns data table's field name specified by Index

property Names[Index: Integer]: string read

---

property NativeDatabaseAccess: IDANativeDatabaseAccess read

---

Implements IDASQLCommandNativeObject by delegating the call to the FNativeDatabaseAccess member.

function NativeFieldCount: Integer

---

property NativeFields[Index: Integer]: IDANativeField read

---

Implements IDASQLCommandNativeObject by delegating the call to the FNativeDatabaseAccess member.

function NativeFindField(const FieldName: string): IDANativeField

Parameters:

• FieldName: name of the searched field

---

Access to the standard VCL |TObject which implements the data access.

property NativeObject: TObject read

---

Invokes DoNext.

procedure Next

---

Fires right after a command was executed.

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

---

Fires after dataset was opened

property OnAfterOpen: TDAAfterOpenDatasetEvent read write
delegate:  procedure OnAfterOpen(const Sender: IDADataset; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires before command execution

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

---

Fires before dataset was opened

property OnBeforeOpen: TDABeforeOpenDatasetEvent read write
delegate:  procedure OnBeforeOpen(const Sender: IDADataset)

---

Fires when exception is detected during command execution

property OnExecuteError: TDAExecuteCommandErrorEvent read write
delegate:  procedure OnExecuteError(const Sender: IDASQLCommand; ActualSQL: string; Error: Exception)

---

Fired if error was occured duting opening of dataset

property OnOpenError: TDAOpenDatasetErrorEvent read write
delegate:  procedure OnOpenError(const Sender: IDADataset; ActualSQL: string; Error: Exception)

---

Opens the dataset and prepares it for fetching records from the database.

procedure Open

---

Represents the collection of OrderBy statements.

property OrderBy: TDAOrderByCollection read write

---

Locates a specific parameter, based on its name. If no matching parameter is defined, an exception will be raised.

function ParamByName(const aName: string): TDAParam

Parameters:

• aName: name of the parameter

---

Provides access to the list of parameters defined for the command.

property Params: TDAParamCollection read

---

Specifies whether the SQL statement has been prepared for execution on the database (true) or not (false). Setting this property to true will automatically prepare the statement. Preparing statements on the database server allows for faster execution, especially if the statement will be executed multiple times, as the server will not need to re-parse the SQL text for every execution. Please refer to your database system's documentation for more information on preparing statements.

Note that changing the SQL or Where properties will automatically un-prepare the statement.

property Prepared: Boolean read write

---

Builds a well formed SQL instruction and prepares it via DoPrepare.

procedure PrepareSQLStatement

---

Returns the count of records

property RecordCount: Integer read

---

procedure RecreateCachedParams(aParams: TParams)

Parameters:

• aParams:

---

Reopens the dataset.

procedure Refresh

---

Refreshes the list of parameters defined for the command based on the actual parameter names found in the SQL statement and Where clause.

procedure RefreshParams

---

Returns -1

property RowRecIdValue: Integer read

---

Activates (True) or deactivates (False) the dataset.

procedure SetActive(Value: Boolean)

Parameters:

• Value: mode

---

Converts values from Data Abstract TDAParam values.

procedure SetParamValues(Params: TDAParamCollection)

Parameters:

• Params: parameters

---

Utility method to set the values of Params2 (|TParams) for the daptOutput, daptInputOutput and daptResult parameters of Params1 (TDAParamCollection).

procedure SetParamValuesStd(Params1: TDAParamCollection; Params2: TParams)

Parameters:

• Params1: Parameters guide
• Params2: Values holder

---

Defines the SQL statement to be executed.

property SQL: string read write

---

Checks if SQL contains Dynamic Where macros.

function SQLContainsDynamicWhere: Boolean

---

Determines the current operating mode of the dataset. The state property determines which operations can be performed with the data in the dataset, such as editing existing records or inserting new ones. The dataset state constantly changes as the application processes data.

property State: TDatasetState read

---

Where clause as plain string:

  (table.Field = 25) or (table.Field2 = "test")

property WhereClause: string read write

 

Specifies whether the dataset is currently active (open) or not. Setting this property to true will automatically open the dataset, while setting it to false will automatically close it.

property Active: Boolean read write

---

property CachedParams: TDictionary<string, Integer> read

---

Indicates that SQL was changed and PrepareSQLStatement should be called

property Changed: Boolean read write

---

Presents the IDAConnection to access information about available databases, tables, columns, etc.

property Connection: IDAConnection read

---

Connection

property Connection: TDAEConnection read

---

not supported

property CurrentRecIdValue: Integer read write

---

Access to the standard VCL TDataSet.

property Dataset: TDataset read

---

Implementation of Dynamic Where.

property DynamicWhere: TDAWhereBuilder read write

---

Indicates whether reading the dataset has reached the end of the recordset (EOF = End of File). EOF will only turn true if neither an empty dataset was opened or Next was called while the cursor was already on the last record (it will not turn to true when reaching the last record).

property Eof: Boolean read

---

Indicates the number of fields contained in the dataset.

property FieldCount: Integer read

---

Provides access to all the fields contained in the dataset.

property Fields: TDAFieldCollection read

---

Provides convenient access to all the fields values of the current record without having to go though the Fields collection property.

property FieldValues[Index: Integer]: Variant read

---

Indicates whether the dataset contains no records.

property IsEmpty: Boolean read

---

Defines the name of the data table.

property LogicalName: string read write

---

Returns a human-readable name for the command.

property Name: string read

---

Returns data table's field name specified by Index

property Names[Index: Integer]: string read

---

property NativeDatabaseAccess: IDANativeDatabaseAccess read

---

property NativeFields[Index: Integer]: IDANativeField read

---

Access to the standard VCL |TObject which implements the data access.

property NativeObject: TObject read

---

Represents the collection of OrderBy statements.

property OrderBy: TDAOrderByCollection read write

---

Provides access to the list of parameters defined for the command.

property Params: TDAParamCollection read

---

Specifies whether the SQL statement has been prepared for execution on the database (true) or not (false). Setting this property to true will automatically prepare the statement. Preparing statements on the database server allows for faster execution, especially if the statement will be executed multiple times, as the server will not need to re-parse the SQL text for every execution. Please refer to your database system's documentation for more information on preparing statements.

Note that changing the SQL or Where properties will automatically un-prepare the statement.

property Prepared: Boolean read write

---

Returns the count of records

property RecordCount: Integer read

---

Returns -1

property RowRecIdValue: Integer read

---

Defines the SQL statement to be executed.

property SQL: string read write

---

Determines the current operating mode of the dataset. The state property determines which operations can be performed with the data in the dataset, such as editing existing records or inserting new ones. The dataset state constantly changes as the application processes data.

property State: TDatasetState read

---

Where clause as plain string:

  (table.Field = 25) or (table.Field2 = "test")

property WhereClause: string read write

 

Creates a new instance.

constructor Create(aConnection: IDAConnection; aDataset: TDataset; const aName: string)

Parameters:

• aConnection: Connection
• aDataset: Dataset
• aName: Name

---

Creates a new instance.

constructor Create(aConnection: TDAEConnection; const aName: string)

Parameters:

• aConnection:
• aName:

---

Specifies that given field can return data in GetNativeFieldData method

function CanUseNativeFieldData(Index: Integer): Boolean

Parameters:

• Index: Required field index

---

Clears parameter values.

procedure ClearParams

---

Closes the dataset

procedure Close

---

Indicates whether data-aware controls update their display to reflect changes to the dataset.

function ControlsDisabled: Boolean

---

Creates native dataset object

function CreateDataset(aConnection: TDAEConnection): TDataset

Parameters:

• aConnection: owner connection

---

Creates an IDANativeDatabaseAccess implementor.

function CreateNativeDatabaseAccess: IDANativeDatabaseAccess

---

Creates the native object.

function CreateNativeObject(aConnection: TDAEConnection): TObject

Parameters:

• aConnection: connection

---

Disables dataset constraints

procedure DisableConstraints

---

Disables data display in data-aware controls associated with the dataset.

procedure DisableControls

---

Creates a object specific to the given connection.

function DoCreateNativeObject: TObject

---

Executes SQL statement

function DoExecute: Integer

---

Returns current state

function DoGetActive: Boolean

---

Indicates whether reading the dataset has reached the beginning of the recordset (BOF = Beginning of File). GetBOF will only turn true if neither an empty dataset was opened nor Prior was called while the cursor was on the first record (it will not turn to true automatically when reaching the first record).

function DoGetBOF: Boolean

---

Indicates whether reading the dataset has reached the end of the recordset (EOF = End of File). EOF will only turn true if neither an empty dataset was opened or Next was called while the cursor was already on the last record (it will not turn to true when reaching the last record).

function DoGetEOF: Boolean

---

Returns the counf of records

function DoGetRecordCount: Integer

---

Gets the SQL statement

function DoGetSQL: string

---

Locates and activates a record by key values.

function DoLocate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean

Parameters:

• KeyFields: The semicolon-separated list of fields.
• KeyValues: Values specified by the Variant or Variant array.
• Options: Indicates whether the search is case insensitive and whether partial matches are supported.

---

Returns the result of the NativeDatabaseAccess.Next invocation. Please refer to the article How to create a Data Abstract Driver (Delphi) for more details.

procedure DoNext

---

Sets the property Prepared of the referred dataset to AValue.

procedure DoPrepare(Value: Boolean)

Parameters:

• Value: state

---

Activates (True) or deactivates (False) the dataset. If the Value is true, the MacroProcessor of the active connection processes the Dynamic Where, retrieves and sets up the query parameters, activates the underlaid dataset (NativeDatabaseAccess) and binds the fields. If the Value is false, the underlaid dataset (NativeDatabaseAccess) is deactivated and the fields are unbound or cleared. Please refer to the article How to create a Data Abstract Driver (Delphi) for more details.

procedure DoSetActive(Value: Boolean)

Parameters:

• Value: mode

---

Sets the SQL statement

procedure DoSetSQL(const Value: string)

Parameters:

• Value: SQL statement

---

Enables dataset constraints

procedure EnableConstraints

---

Enables data display in data-aware controls associated with the dataset.

procedure EnableControls

---

Executes the SQL command.

function Execute: Integer

---

Finds a field based on its name. If the specified field does not exist, FieldByName raises an exception.

function FieldByName(const aName: string): TDAField

Parameters:

• aName: name of the searched field

---

function FindCachedParameter(const AParams: TParams; const AParamName: string): TParam

Parameters:

• AParams:
• AParamName:

---

Returns an item with the specified name.

function FindField(const aName: string): TDAField

Parameters:

• aName: name of the searched field

---

Finds the AParamName parameter in the |TParams collection.

function FindParameter(const AParams: TParams; const AParamName: string): TParam

Parameters:

• AParams:
• AParamName:

---

Corrects a known issue with parameters that have ftFMTBcd type.

procedure FixFMTBCDIssue

---

Fixes known problems. at this moment, it can call FixFMTBCDIssue if it is required

procedure FixKnownIssues

---

Frees the resources allocated for a specified bookmark.

procedure FreeBookmark(Bookmark: TBookmark)

Parameters:

• Bookmark: bookmark that should be freed

---

Returns the result of the DoGetActive invocation.

function GetActive: Boolean

---

Indicates whether reading the dataset has reached the beginning of the recordset (BOF = Beginning of File). GetBOF will only turn true if neither an empty dataset was opened nor Prior was called while the cursor was on the first record (it will not turn to true automatically when reaching the first record).

function GetBOF: Boolean

---

Allocates a bookmark for the active record

function GetBookMark: Pointer

---

Returns instance of used macro processor.

function GetCurrentMacroProcessor: TDASQLMacroProcessor

---

Implements IDASQLCommand by returning the result of CreateDataset.

function GetDataset: TDataset

---

Returns value of data table's field specified by index

function GetFieldValues(Index: Integer): Variant

Parameters:

• Index: index of the field

---

Implements IDASQLCommand by returning a value set in the constructor.

function GetName: string

---

Sets the DataSize to the according field size value, allocates the Data memory and copies the content of the field.

function GetNativeFieldData(Index: Integer; var Buffer: TBytes): Boolean

Parameters:

• Index: Required field index
• Buffer:

---

Returns the field type of the Index field

function GetNativeFieldDataType(Index: Integer): TFieldType

Parameters:

• Index: field index

---

Implements IDASQLCommand by returning the current parameters.

function GetParams: TDAParamCollection

---

Retrieves the values of the given parameters.

procedure GetParamValues(Params: TDAParamCollection)

Parameters:

• Params: Parameters

---

Retrieves the values from Params2 for the daptOutput, daptInputOutput and daptResult parameters of Params1.

procedure GetParamValuesStd(Params1: TDAParamCollection; Params2: TParams)

Parameters:

• Params1: Parameters guide
• Params2: Values source

---

function GetRowRecIDValue: Integer

---

Positions on the record to which a specified bookmark points.

procedure GotoBookmark(Bookmark: TBookmark)

Parameters:

• Bookmark: record identified by this Bookmark should be active

---

Gets mapping |TFieldType to TDADataType.

function intVCLTypeToDAType(aFieldType: TFieldType; ASize: Integer; ADecimalPrecision: Integer; aDecimalScale: Integer): TDADataType

Parameters:

• aFieldType:
• ASize:
• ADecimalPrecision:
• aDecimalScale:

---

Indicates the special mode in which (0=1) where statement is added to Dynamic Where.

function isConnectioninRefreshFieldsMode: Boolean

---

This is a virtual method (instrumental interface) to correct possible incompatibilities of the concrete implementation of the dataset (the known issue with the ZEOS driver). Please refer to the article How to create a Data Abstract Driver (Delphi) for more details.

function IsNeedToFixFMTBCDIssue: Boolean

---

Returns true if data access object is TDataset descendant.

function IsTDatasetCompatible: Boolean

---

Locates and activates a record by key values.

function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean

Parameters:

• KeyFields: The semicolon-separated list of fields.
• KeyValues: Values specified by the Variant or Variant array.
• Options: Indicates whether the search is case insensitive and whether partial matches are supported.

---

Returns the result of the NativeDatabaseAccess.Lookup invocation.

function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant

Parameters:

• KeyFields: Comma-delimited list of fields
• KeyValues: Variant or Variant array of values
• ResultFields: Comma-delimited list of fields

---

Implements IDASQLCommandNativeObject by delegating the call to the FNativeDatabaseAccess member.

function NativeFieldCount: Integer

---

Implements IDASQLCommandNativeObject by delegating the call to the FNativeDatabaseAccess member.

function NativeFindField(const FieldName: string): IDANativeField

Parameters:

• FieldName: name of the searched field

---

Invokes DoNext.

procedure Next

---

Opens the dataset and prepares it for fetching records from the database.

procedure Open

---

Locates a specific parameter, based on its name. If no matching parameter is defined, an exception will be raised.

function ParamByName(const aName: string): TDAParam

Parameters:

• aName: name of the parameter

---

Builds a well formed SQL instruction and prepares it via DoPrepare.

procedure PrepareSQLStatement

---

procedure RecreateCachedParams(aParams: TParams)

Parameters:

• aParams:

---

Reopens the dataset.

procedure Refresh

---

Refreshes the list of parameters defined for the command based on the actual parameter names found in the SQL statement and Where clause.

procedure RefreshParams

---

Activates (True) or deactivates (False) the dataset.

procedure SetActive(Value: Boolean)

Parameters:

• Value: mode

---

Converts values from Data Abstract TDAParam values.

procedure SetParamValues(Params: TDAParamCollection)

Parameters:

• Params: parameters

---

Utility method to set the values of Params2 (|TParams) for the daptOutput, daptInputOutput and daptResult parameters of Params1 (TDAParamCollection).

procedure SetParamValuesStd(Params1: TDAParamCollection; Params2: TParams)

Parameters:

• Params1: Parameters guide
• Params2: Values holder

---

Checks if SQL contains Dynamic Where macros.

function SQLContainsDynamicWhere: Boolean

 

Fires right after a command was executed.

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

---

Fires after dataset was opened

property OnAfterOpen: TDAAfterOpenDatasetEvent read write
delegate:  procedure OnAfterOpen(const Sender: IDADataset; ActualSQL: string; ElapsedMilliseconds: Cardinal)

---

Fires before command execution

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

---

Fires before dataset was opened

property OnBeforeOpen: TDABeforeOpenDatasetEvent read write
delegate:  procedure OnBeforeOpen(const Sender: IDADataset)

---

Fires when exception is detected during command execution

property OnExecuteError: TDAExecuteCommandErrorEvent read write
delegate:  procedure OnExecuteError(const Sender: IDASQLCommand; ActualSQL: string; Error: Exception)

---

Fired if error was occured duting opening of dataset

property OnOpenError: TDAOpenDatasetErrorEvent read write
delegate:  procedure OnOpenError(const Sender: IDADataset; ActualSQL: string; Error: Exception)