TCustomSQLQuery

type TCustomSQLQuery = class(TCustomBufDataset)

protected

  procedure OpenCursor(); override;

  function CreateSQLStatement(); virtual;

  function CreateParams; virtual;

  function RefreshLastInsertID(); virtual;

  function NeedRefreshRecord(); virtual;

  function RefreshRecord(); virtual;

  procedure ApplyReturningResult();

  function Cursor;

  function LogEvent();

  procedure Log(); virtual;

  function Fetch; override;

  function LoadField(); override;

  procedure LoadBlobIntoBuffer(); override;

  procedure ApplyRecUpdate(); override;

  procedure SetPacketRecords(); override;

  procedure UpdateServerIndexDefs; virtual;

  procedure SetDatabase(); override;

  procedure SetTransaction(); override;

  procedure InternalAddRecord(); override;

  procedure InternalClose; override;

  procedure InternalInitFieldDefs; override;

  procedure InternalOpen; override;

  procedure InternalRefresh; override;

  function GetCanModify; override;

  function IsPrepared; virtual;

  procedure SetServerFiltered(); virtual;

  procedure SetServerFilterText(); virtual;

  function GetDataSource; override;

  procedure SetDataSource();

  procedure BeforeRefreshOpenCursor; override;

  procedure SetReadOnly(); override;

  procedure Notification(); override;

  procedure DoOnNewRecord; override;

  procedure DoBeforePost; override;

  class function FieldDefsClass; override;

  function PSGetUpdateException(); override;

  function PSGetTableName; override;

  property TableName: string; [rw]

public

  constructor Create(); override;

  destructor Destroy; override;

  procedure Prepare; virtual;

  procedure UnPrepare; virtual;

  procedure ExecSQL; virtual;

  procedure SetSchemaInfo(); virtual;

  function RowsAffected; virtual;

  function ParamByName();

  function MacroByName();

  property Prepared: Boolean; [r]

  property SQLConnection: TSQLConnection; [rw]

  property SQLTransaction: TSQLTransaction; [rw]

  procedure ApplyUpdates(); override; overload;

  procedure Post; override;

  procedure Delete; override;

protected

  property Active: Boolean;

  property Filter: string;

  property Filtered: Boolean;

  property BeforeOpen: TDataSetNotifyEvent;

  property AfterOpen: TDataSetNotifyEvent;

  property BeforeClose: TDataSetNotifyEvent;

  property AfterClose: TDataSetNotifyEvent;

  property BeforeInsert: TDataSetNotifyEvent;

  property AfterInsert: TDataSetNotifyEvent;

  property BeforeEdit: TDataSetNotifyEvent;

  property AfterEdit: TDataSetNotifyEvent;

  property BeforePost: TDataSetNotifyEvent;

  property AfterPost: TDataSetNotifyEvent;

  property BeforeCancel: TDataSetNotifyEvent;

  property AfterCancel: TDataSetNotifyEvent;

  property BeforeDelete: TDataSetNotifyEvent;

  property AfterDelete: TDataSetNotifyEvent;

  property BeforeRefresh: TDataSetNotifyEvent;

  property AfterRefresh: TDataSetNotifyEvent;

  property BeforeScroll: TDataSetNotifyEvent;

  property AfterScroll: TDataSetNotifyEvent;

  property OnCalcFields: TDataSetNotifyEvent;

  property OnDeleteError: TDataSetErrorEvent;

  property OnEditError: TDataSetErrorEvent;

  property OnFilterRecord: TFilterRecordEvent;

  property OnNewRecord: TDataSetNotifyEvent;

  property OnPostError: TDataSetErrorEvent;

  property AutoCalcFields: Boolean;

  property Database: TDataBase;

  property Transaction: TDBTransaction;

  property SchemaType: TSchemaType; [r]

  property SQL: TStringlist; [rw]

  property InsertSQL: TStringList; [rw]

  property UpdateSQL: TStringList; [rw]

  property DeleteSQL: TStringList; [rw]

  property RefreshSQL: TStringList; [rw]

  property Options: TSQLQueryOptions; [rw]

  property Params: TParams; [rws]

  property ParamCheck: Boolean; [rw]

  property Macros: TParams; [rws]

  property MacroCheck: Boolean; [rw]

  property MacroChar: Char; [rw]

  property ParseSQL: Boolean; [rw]

  property UpdateMode: TUpdateMode; [rw]

  property UsePrimaryKeyAsKey: Boolean; [rw]

  property StatementType: TStatementType; [r]

  property DataSource: TDataSource; [rw]

  property Sequence: TSQLSequence; [rw]

  property ServerFilter: string; [rw]

  property ServerFiltered: Boolean; [rw]

  property ServerIndexDefs: TServerIndexDefs; [r]

end;

TCustomSQLQuery

TCustomBufDataset

TDBDataset

TDataSet

TObject