Icon TDBISAMQuery Component

Removed Properties, Methods and Events
The following are the properties, methods, and events that have been removed for the component:

Properties

RemovedDescription
TableNameThis property is no longer supported.

Methods

RemovedDescription
SaveToTableThis method is no longer supported. In ElevateDB, use the AS clause of the CREATE TABLE to create a table that is based upon a query expression.

Events

RemovedDescription
BeforeExecute
AfterExecute
OnGetParams
OnQueryError
These events are no longer supported. ElevateDB does not support multi-statement scripts in the TEDBQuery component.
OnAlterProgress
OnDataLost
OnCopyProgress
These events are no longer necessary. ElevateDB uses SQL for all table and index creation, alteration, or drops, and the OnLogMessage, OnProgress, and OnStatusMessage events provide the same functionality.
OnExportProgress
OnImportProgress
These events are no longer necessary. ElevateDB uses SQL for importing and exporting tables, and the OnLogMessage, OnProgress, and OnStatusMessage events provide the same functionality.
OnOptimizeProgress
OnRepairProgress
OnRepairLog
OnVerifyProgress
OnVerifyLog
OnUpgradeProgress
OnUpgradeLog
These events are no longer necessary. ElevateDB uses SQL for all administrative functionality, and the OnLogMessage, OnProgress, and OnStatusMessage events provide the same functionality.
OnQueryProgressThis event is no longer necessary. The OnProgress event provides the same functionality.
OnSaveProgressThis event is no longer supported since the SaveToTable method is no longer supported. In ElevateDB, use the AS clause of the CREATE TABLE to create a table that is based upon a query expression.

Property, Method, and Event Changes
The following are the changes to the properties, methods, and events for the component:

Properties

ChangedDescription
GeneratePlanThis property has been renamed to the RequestPlan property.
ParamsThis property no longer uses a custom TDBISAMParams type for the parameter definitions collection. In ElevateDB this property uses the standard TParams collection type.
RequestLiveThis property has been renamed to the RequestSensitive property.
ResultIsLiveThis property has been renamed to the Sensitive property.
SQLThis property only accepts a single SQL statement in ElevateDB. DBISAM allow for multi-statement scripts.
SQLStatementTypeThis property has been renamed to the StatementType property.
StmtHandleThis property has been renamed to the StatementHandle property.

Methods

ChangedDescription
None

Events

ChangedDescription
None

New Properties, Methods, and Events
The following are the new properties, methods, and events added in the new ElevateDB component:

Properties

NewDescription
ConstrainedThis property allows you to specify that any inserts or updates made to a sensitive result set be subject to the WHERE clause used in the current SELECT statement.

Methods

NewDescription
None

Events

NewDescription
None
Image