Class tsqlquery

Unit

msesqlquery

Declaration

type tsqlquery = class(tmsebufdataset, isqlclient, icursorclient)

Description

Hierarchy

• TDataset
• tmdbdataset
• tmsebufdataset
• tsqlquery

Overview

Fields

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

Methods

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

Properties

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

Description

Fields

	fmstate: sqlquerystatesty;

	FTableName: string;

	FReadOnly: boolean;

	fprimarykeyfield: tfield;

	futf8: boolean;

	foptionsmasterlink: optionsmasterlinkty;

Methods

	function getdatabase: tcustomconnection;

	procedure settransactionwrite(const avalue: tmdbtransaction); override;

	procedure checkpendingupdates; virtual;

	procedure notification(acomponent: tcomponent; operation: toperation); override;

	function Fetch: boolean; override;

	function getblobdatasize: integer; override;

	function getnumboolean: boolean; virtual;

	function getfloatdate: boolean; virtual;

	function getint64currency: boolean; virtual;

	function blobscached: boolean; override;

	function loadfield(const afieldno: integer; const afieldtype: tfieldtype; const buffer: pointer; var bufsize: integer): boolean; override;

	procedure updateindexdefs; override;

	procedure setdatabase(const value: tmdatabase); override;

	procedure settransaction(const value : tmdbtransaction); override;

	procedure internaladdrecord(buffer: pointer; aappend: boolean); override;

	procedure internalclose; override;

	procedure internalinitfielddefs; override;

	procedure connect(const aexecute: boolean);

	procedure freemodifyqueries;

	procedure freequery;

	procedure disconnect;

	procedure checkrecursivedatasource(const avalue: tdatasource);

	procedure internalopen; override;

	procedure internalrefresh; override;

	procedure refreshtransaction; override;

	procedure dobeforeedit; override;

	procedure dobeforeinsert; override;

	procedure dataevent(event: tdataevent; info: ptrint); override;

	function getcanmodify: boolean; override;

	procedure updatewherepart(var sql_where : msestring; const afield: tfield);

	procedure internalapplyrecupdate(updatekind : tupdatekind);

	procedure dobeforeapplyupdate; override;

	procedure applyrecupdate(updatekind : tupdatekind); override;

	function isprepared: boolean; virtual;

	Procedure SetActive(Value : Boolean); override;

	procedure SetFiltered(Value: Boolean); override;

	procedure SetFilterText(const Value: string); override;

	Function GetDataSource: TDatasource; override;

	Procedure SetDataSource(AValue : TDatasource);

	function stringmemo: boolean; virtual;

	constructor Create(AOwner : TComponent); override;

	destructor Destroy; override;

	function isutf8: boolean; override;

	procedure applyupdate(const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); override;

	procedure applyupdates(const maxerrors: integer; const cancelonerror: boolean; const cancelondeleteerror: boolean = false; const editonerror: boolean = false); override;

	function refreshrecquery(const update: boolean): msestring;

	procedure checktablename;

	function updaterecquery: msestring;

	function insertrecquery: msestring;

	function deleterecquery: msestring;

	function writetransaction: tsqltransaction;

	procedure refresh(const aparams: array of variant); overload;

	procedure Prepare; virtual;

	procedure UnPrepare; virtual;

	procedure ExecSQL; virtual;

	function executedirect(const asql: msestring): integer;

	function rowsreturned: integer;

	function rowsaffected: integer;

	function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override;

Properties

	property updaterowsaffected: integer read fupdaterowsaffected;

	property Prepared : boolean read IsPrepared;

	property connected: boolean read getconnected write setconnected;

	property ReadOnly : Boolean read FReadOnly write SetReadOnly default false;

	property ParseSQL : Boolean read FParseSQL write SetParseSQL default true;

	property params : tmseparams read fparams write setparams;

	property SQL : tsqlstringlist read FSQL write setFSQL;

	property SQLUpdate : tupdatestringlist read Fapplysql[ukmodify] write setFSQLUpdate;

	property SQLInsert : tupdatestringlist read Fapplysql[ukinsert] write setFSQLInsert;

	property SQLDelete : tupdatestringlist read Fapplysql[ukdelete] write setFSQLDelete;

	property beforeexecute: tcustomsqlstatement read fbeforeexecute write setbeforeexecute;

	property aftercursorclose: tcustomsqlstatement read faftercursorclose write setaftercursorclose;

	property IndexDefs : TIndexDefs read GetIndexDefs;

	property UpdateMode : TUpdateMode read FUpdateMode write SetUpdateMode;

	property UsePrimaryKeyAsKey : boolean read FUsePrimaryKeyAsKey write SetUsePrimaryKeyAsKey;

	property tablename: string read ftablename write settablename;

	property StatementType : TStatementType read fstatementtype write setstatementtype default stnone;

	property DataSource : TDatasource Read GetDataSource Write SetDatasource;

	property masterdelayus: integer read fmasterdelayus write fmasterdelayus default -1;

	property optionsmasterlink: optionsmasterlinkty read foptionsmasterlink write foptionsmasterlink default [];

	property database: tcustomsqlconnection read getdatabase1 write setdatabase1;

	property Active;

	property Filter;

	property Filtered;

	property BeforeOpen;

	property AfterOpen;

	property BeforeClose;

	property AfterClose;

	property BeforeInsert;

	property AfterInsert;

	property BeforeEdit;

	property AfterEdit;

	property BeforePost;

	property AfterPost;

	property BeforeCancel;

	property AfterCancel;

	property BeforeDelete;

	property AfterDelete;

	property BeforeScroll;

	property AfterScroll;

	property BeforeRefresh;

	property AfterRefresh;

	property OnCalcFields;

	property OnDeleteError;

	property OnEditError;

	property OnFilterRecord;

	property OnNewRecord;

	property OnPostError;

	property onmodified;

	property AutoCalcFields;

	property Transaction: tsqltransaction read getsqltransaction write setsqltransaction;

	property transactionwrite: tsqltransaction read getsqltransactionwrite write setsqltransactionwrite;

---

Generated by PasDoc 0.16.0.