Class tsqlquery

Unit

Declaration

type tsqlquery = class(tmsebufdataset, isqlclient, icursorclient)

Description

No description available, ancestor tmsebufdataset description follows
No description available, ancestor tmdbdataset description follows

Hierarchy

Overview

Fields

Protected fmstate: sqlquerystatesty;
Protected FTableName: string;
Protected FReadOnly: boolean;
Protected fprimarykeyfield: tfield;
Protected futf8: boolean;
Protected foptionsmasterlink: optionsmasterlinkty;

Methods

Protected function getdatabase: tcustomconnection;
Protected procedure settransactionwrite(const avalue: tmdbtransaction); override;
Protected procedure checkpendingupdates; virtual;
Protected procedure notification(acomponent: tcomponent; operation: toperation); override;
Protected function Fetch: boolean; override;
Protected function getblobdatasize: integer; override;
Protected function getnumboolean: boolean; virtual;
Protected function getfloatdate: boolean; virtual;
Protected function getint64currency: boolean; virtual;
Protected function blobscached: boolean; override;
Protected function loadfield(const afieldno: integer; const afieldtype: tfieldtype; const buffer: pointer; var bufsize: integer): boolean; override;
Protected procedure updateindexdefs; override;
Protected procedure setdatabase(const value: tmdatabase); override;
Protected procedure settransaction(const value : tmdbtransaction); override;
Protected procedure internaladdrecord(buffer: pointer; aappend: boolean); override;
Protected procedure internalclose; override;
Protected procedure internalinitfielddefs; override;
Protected procedure connect(const aexecute: boolean);
Protected procedure freemodifyqueries;
Protected procedure freequery;
Protected procedure disconnect;
Protected procedure checkrecursivedatasource(const avalue: tdatasource);
Protected procedure internalopen; override;
Protected procedure internalrefresh; override;
Protected procedure refreshtransaction; override;
Protected procedure dobeforeedit; override;
Protected procedure dobeforeinsert; override;
Protected procedure dataevent(event: tdataevent; info: ptrint); override;
Protected function getcanmodify: boolean; override;
Protected procedure updatewherepart(var sql_where : msestring; const afield: tfield);
Protected procedure internalapplyrecupdate(updatekind : tupdatekind);
Protected procedure dobeforeapplyupdate; override;
Protected procedure applyrecupdate(updatekind : tupdatekind); override;
Protected function isprepared: boolean; virtual;
Protected Procedure SetActive(Value : Boolean); override;
Protected procedure SetFiltered(Value: Boolean); override;
Protected procedure SetFilterText(const Value: string); override;
Protected Function GetDataSource: TDatasource; override;
Protected Procedure SetDataSource(AValue : TDatasource);
Protected function stringmemo: boolean; virtual;
Public constructor Create(AOwner : TComponent); override;
Public destructor Destroy; override;
Public function isutf8: boolean; override;
Public procedure applyupdate(const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); override;
Public procedure applyupdates(const maxerrors: integer; const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); override;
Public function refreshrecquery(const update: boolean): msestring;
Public procedure checktablename;
Public function updaterecquery: msestring;
Public function insertrecquery: msestring;
Public function deleterecquery: msestring;
Public function writetransaction: tsqltransaction;
Public procedure refresh(const aparams: array of variant); overload;
Public procedure Prepare; virtual;
Public procedure UnPrepare; virtual;
Public procedure ExecSQL; virtual;
Public function executedirect(const asql: msestring): integer;
Public function rowsreturned: integer;
Public function rowsaffected: integer;
Public function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override;

Properties

Public property updaterowsaffected: integer read fupdaterowsaffected;
Public property Prepared : boolean read IsPrepared;
Public property connected: boolean read getconnected write setconnected;
Published property ReadOnly : Boolean read FReadOnly write SetReadOnly default false;
Published property ParseSQL : Boolean read FParseSQL write SetParseSQL default true;
Published property params : tmseparams read fparams write setparams;
Published property SQL : tsqlstringlist read FSQL write setFSQL;
Published property SQLUpdate : tupdatestringlist read Fapplysql[ukmodify] write setFSQLUpdate;
Published property SQLInsert : tupdatestringlist read Fapplysql[ukinsert] write setFSQLInsert;
Published property SQLDelete : tupdatestringlist read Fapplysql[ukdelete] write setFSQLDelete;
Published property beforeexecute: tcustomsqlstatement read fbeforeexecute write setbeforeexecute;
Published property aftercursorclose: tcustomsqlstatement read faftercursorclose write setaftercursorclose;
Published property IndexDefs : TIndexDefs read GetIndexDefs;
Published property UpdateMode : TUpdateMode read FUpdateMode write SetUpdateMode;
Published property UsePrimaryKeyAsKey : boolean read FUsePrimaryKeyAsKey write SetUsePrimaryKeyAsKey;
Published property tablename: string read ftablename write settablename;
Published property StatementType : TStatementType read fstatementtype write setstatementtype default stnone;
Published property DataSource : TDatasource Read GetDataSource Write SetDatasource;
Published property masterdelayus: integer read fmasterdelayus write fmasterdelayus default -1;
Published property optionsmasterlink: optionsmasterlinkty read foptionsmasterlink write foptionsmasterlink default [];
Published property database: tcustomsqlconnection read getdatabase1 write setdatabase1;
Published property Active;
Published property Filter;
Published property Filtered;
Published property BeforeOpen;
Published property AfterOpen;
Published property BeforeClose;
Published property AfterClose;
Published property BeforeInsert;
Published property AfterInsert;
Published property BeforeEdit;
Published property AfterEdit;
Published property BeforePost;
Published property AfterPost;
Published property BeforeCancel;
Published property AfterCancel;
Published property BeforeDelete;
Published property AfterDelete;
Published property BeforeScroll;
Published property AfterScroll;
Published property BeforeRefresh;
Published property AfterRefresh;
Published property OnCalcFields;
Published property OnDeleteError;
Published property OnEditError;
Published property OnFilterRecord;
Published property OnNewRecord;
Published property OnPostError;
Published property onmodified;
Published property AutoCalcFields;
Published property Transaction: tsqltransaction read getsqltransaction write setsqltransaction;
Published property transactionwrite: tsqltransaction read getsqltransactionwrite write setsqltransactionwrite;

Description

Fields

Protected fmstate: sqlquerystatesty;
 
Protected FTableName: string;
 
Protected FReadOnly: boolean;
 
Protected fprimarykeyfield: tfield;
 
Protected futf8: boolean;
 
Protected foptionsmasterlink: optionsmasterlinkty;
 

Methods

Protected function getdatabase: tcustomconnection;
 
Protected procedure settransactionwrite(const avalue: tmdbtransaction); override;
 
Protected procedure checkpendingupdates; virtual;
 
Protected procedure notification(acomponent: tcomponent; operation: toperation); override;
 
Protected function Fetch: boolean; override;
 
Protected function getblobdatasize: integer; override;
 
Protected function getnumboolean: boolean; virtual;
 
Protected function getfloatdate: boolean; virtual;
 
Protected function getint64currency: boolean; virtual;
 
Protected function blobscached: boolean; override;
 
Protected function loadfield(const afieldno: integer; const afieldtype: tfieldtype; const buffer: pointer; var bufsize: integer): boolean; override;
 
Protected procedure updateindexdefs; override;
 
Protected procedure setdatabase(const value: tmdatabase); override;
 
Protected procedure settransaction(const value : tmdbtransaction); override;
 
Protected procedure internaladdrecord(buffer: pointer; aappend: boolean); override;
 
Protected procedure internalclose; override;
 
Protected procedure internalinitfielddefs; override;
 
Protected procedure connect(const aexecute: boolean);
 
Protected procedure freemodifyqueries;
 
Protected procedure freequery;
 
Protected procedure disconnect;
 
Protected procedure checkrecursivedatasource(const avalue: tdatasource);
 
Protected procedure internalopen; override;
 
Protected procedure internalrefresh; override;
 
Protected procedure refreshtransaction; override;
 
Protected procedure dobeforeedit; override;
 
Protected procedure dobeforeinsert; override;
 
Protected procedure dataevent(event: tdataevent; info: ptrint); override;
 
Protected function getcanmodify: boolean; override;
 
Protected procedure updatewherepart(var sql_where : msestring; const afield: tfield);
 
Protected procedure internalapplyrecupdate(updatekind : tupdatekind);
 
Protected procedure dobeforeapplyupdate; override;
 
Protected procedure applyrecupdate(updatekind : tupdatekind); override;
 
Protected function isprepared: boolean; virtual;
 
Protected Procedure SetActive(Value : Boolean); override;
 
Protected procedure SetFiltered(Value: Boolean); override;
 
Protected procedure SetFilterText(const Value: string); override;
 
Protected Function GetDataSource: TDatasource; override;
 
Protected Procedure SetDataSource(AValue : TDatasource);
 
Protected function stringmemo: boolean; virtual;
 
Public constructor Create(AOwner : TComponent); override;
 
Public destructor Destroy; override;
 
Public function isutf8: boolean; override;
 
Public procedure applyupdate(const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); override;
 
Public procedure applyupdates(const maxerrors: integer; const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); override;
 
Public function refreshrecquery(const update: boolean): msestring;
 
Public procedure checktablename;
 
Public function updaterecquery: msestring;
 
Public function insertrecquery: msestring;
 
Public function deleterecquery: msestring;
 
Public function writetransaction: tsqltransaction;
 
Public procedure refresh(const aparams: array of variant); overload;
 
Public procedure Prepare; virtual;
 
Public procedure UnPrepare; virtual;
 
Public procedure ExecSQL; virtual;
 
Public function executedirect(const asql: msestring): integer;
 
Public function rowsreturned: integer;
 
Public function rowsaffected: integer;
 
Public function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override;
 

Properties

Public property updaterowsaffected: integer read fupdaterowsaffected;
 
Public property Prepared : boolean read IsPrepared;
 
Public property connected: boolean read getconnected write setconnected;
 
Published property ReadOnly : Boolean read FReadOnly write SetReadOnly default false;
 
Published property ParseSQL : Boolean read FParseSQL write SetParseSQL default true;
 
Published property params : tmseparams read fparams write setparams;
 
Published property SQL : tsqlstringlist read FSQL write setFSQL;
 
Published property SQLUpdate : tupdatestringlist read Fapplysql[ukmodify] write setFSQLUpdate;
 
Published property SQLInsert : tupdatestringlist read Fapplysql[ukinsert] write setFSQLInsert;
 
Published property SQLDelete : tupdatestringlist read Fapplysql[ukdelete] write setFSQLDelete;
 
Published property beforeexecute: tcustomsqlstatement read fbeforeexecute write setbeforeexecute;
 
Published property aftercursorclose: tcustomsqlstatement read faftercursorclose write setaftercursorclose;
 
Published property IndexDefs : TIndexDefs read GetIndexDefs;
 
Published property UpdateMode : TUpdateMode read FUpdateMode write SetUpdateMode;
 
Published property UsePrimaryKeyAsKey : boolean read FUsePrimaryKeyAsKey write SetUsePrimaryKeyAsKey;
 
Published property tablename: string read ftablename write settablename;
 
Published property StatementType : TStatementType read fstatementtype write setstatementtype default stnone;
 
Published property DataSource : TDatasource Read GetDataSource Write SetDatasource;
 
Published property masterdelayus: integer read fmasterdelayus write fmasterdelayus default -1;
 
Published property optionsmasterlink: optionsmasterlinkty read foptionsmasterlink write foptionsmasterlink default [];
 
Published property database: tcustomsqlconnection read getdatabase1 write setdatabase1;
 
Published property Active;
 
Published property Filter;
 
Published property Filtered;
 
Published property BeforeOpen;
 
Published property AfterOpen;
 
Published property BeforeClose;
 
Published property AfterClose;
 
Published property BeforeInsert;
 
Published property AfterInsert;
 
Published property BeforeEdit;
 
Published property AfterEdit;
 
Published property BeforePost;
 
Published property AfterPost;
 
Published property BeforeCancel;
 
Published property AfterCancel;
 
Published property BeforeDelete;
 
Published property AfterDelete;
 
Published property BeforeScroll;
 
Published property AfterScroll;
 
Published property BeforeRefresh;
 
Published property AfterRefresh;
 
Published property OnCalcFields;
 
Published property OnDeleteError;
 
Published property OnEditError;
 
Published property OnFilterRecord;
 
Published property OnNewRecord;
 
Published property OnPostError;
 
Published property onmodified;
 
Published property AutoCalcFields;
 
Published property Transaction: tsqltransaction read getsqltransaction write setsqltransaction;
 
Published property transactionwrite: tsqltransaction read getsqltransactionwrite write setsqltransactionwrite;
 

Generated by PasDoc 0.16.0.