TCustomSQLQuery

type TCustomSQLQuery = class(TCustomBufDataset)

public

  constructor Create(); override;

Create a new instance of TCustomSQLQuery.

  destructor Destroy; override;

Destroy instance of TCustomSQLQuery.

  procedure Prepare; virtual;

Prepare a query for execution.

  procedure UnPrepare; virtual;

Unprepare a prepared query.

  procedure ExecSQL; virtual;

Execute a SQL statement that does not return a result set.

  procedure SetSchemaInfo(); virtual;

SetSchemaInfo prepares the dataset to retrieve schema info.

  function RowsAffected; virtual;

Return the number of rows (records) affected by the last DML/DDL statement.

  function ParamByName();

Return parameter by name.

  function MacroByName();

Convenience for Macros.ParamByName.

  property Prepared: Boolean; [r]

Is the query prepared ?

  property SQLConnection: TSQLConnection; [rw]

Database as TSQLConnection.

  property SQLTransaction: TSQLTransaction; [rw]

Transaction as TSQLTransaction.

  procedure ApplyUpdates(); override; overload;

Apply updates and check result.

  procedure Post; override;

Post pending changes and optionally apply updates.

  procedure Delete; override;

Delete and optionally apply updates.

end;

TCustomSQLQuery

Custom Class to handle SQL commands (with or without result set).

TCustomBufDataset

Dataset connected to a database.

TDBDataset

Dataset connected to a database.

TDataSet

Base class for records-based data-access.

TComponent

TPersistent,IUnknown,IInterfaceComponentReference

TObject,IFPObserved

TSQLQuery

Class to handle SQL commands (with or without result set).