Class tsqlresult

Unit

msesqlresult

Declaration

type tsqlresult = class(tcursorsqlstatement, isqlpropertyeditor, isqlclient, itransactionclient)

Description

Hierarchy

• tcursorsqlstatement
• tsqlresult

Overview

Methods

	procedure dosqlchange(const sender : tobject); override;
	function getactive: boolean; override;
	procedure setactive(avalue: boolean); override;
	procedure loaded; override;
	procedure freefldbuffers;
	procedure doclear(const isclose: boolean);
	procedure checkautocommit; override;
	procedure settransaction(const avalue: tmdbtransaction);
	procedure settransactionwrite(const avalue: tmdbtransaction);
	procedure savepointevent(const sender: tmdbtransaction; const akind: savepointeventkindty; const alevel: integer);
	procedure setdatabase(const avalue: tmdatabase);
	function getname: ansistring;
	function gettransaction: tmdbtransaction;
	function getrecno: integer;
	procedure setrecno(value: integer);
	procedure disablecontrols;
	procedure enablecontrols;
	function moveby(distance: longint): longint;
	function getsqltransactionwrite: tsqltransaction;
	procedure setsqltransactionwrite(const avalue: tsqltransaction);
	procedure checkbrowsemode;
	procedure refreshtransaction;
	procedure internalloaddatalists(const acols: integerarty; const datalists: array of tdatalist);
	constructor create(aowner: tcomponent); override;
	destructor destroy; override;
	procedure prepare; override;
	procedure unprepare; override;
	procedure open(const aparams: array of variant);
	procedure open();
	procedure close;
	procedure clear;
	procedure refresh(const aparams: array of variant);
	procedure refresh;
	procedure next;
	function countrest(): int32;
	function rowsaffected: integer;
	function rowsreturned: integer;
	function asvariant(const aclose: boolean = false): variant;
	function asvariantar(const aclose: boolean = false): variantarty;
	function asvariantarar(const aclose: boolean = false): variantararty;
	procedure loaddatalists(const datalists: array of tdatalist);

Properties

	property datacols: tdbcols read fdatacols;
	property cols[constindex:int32]: tdbcol read getcols write setcols;
	property bof: boolean read fbof;
	property eof: boolean read feof;
	property beforeopen: tmsesqlscript read fbeforeopen write setbeforeopen;
	property afteropen: tmsesqlscript read fafteropen write setafteropen;
	property active: boolean read getactive write setactive default false;
	property fielddefs: tsqlresultfielddefs read ffielddefs write setfielddefs;
	property onbeforeopen: sqlresulteventty read fonbeforeopen write fonbeforeopen;
	property onafteropen: sqlresulteventty read fonafteropen write fonafteropen;
	property params;
	property sql;
	property database;
	property transaction;
	property options;
	property statementtype default stselect;
	property onbeforeexecute;
	property onafterexecute;
	property onerror;

Description

Methods

	procedure dosqlchange(const sender : tobject); override;

	function getactive: boolean; override;

	procedure setactive(avalue: boolean); override;

	procedure loaded; override;

	procedure freefldbuffers;

	procedure doclear(const isclose: boolean);

	procedure checkautocommit; override;

	procedure settransaction(const avalue: tmdbtransaction);

	procedure settransactionwrite(const avalue: tmdbtransaction);

	procedure savepointevent(const sender: tmdbtransaction; const akind: savepointeventkindty; const alevel: integer);

	procedure setdatabase(const avalue: tmdatabase);

	function getname: ansistring;

	function gettransaction: tmdbtransaction;

	function getrecno: integer;

	procedure setrecno(value: integer);

	procedure disablecontrols;

	procedure enablecontrols;

	function moveby(distance: longint): longint;

	function getsqltransactionwrite: tsqltransaction;

	procedure setsqltransactionwrite(const avalue: tsqltransaction);

	procedure checkbrowsemode;

	procedure refreshtransaction;

	procedure internalloaddatalists(const acols: integerarty; const datalists: array of tdatalist);

	constructor create(aowner: tcomponent); override;

	destructor destroy; override;

	procedure prepare; override;

	procedure unprepare; override;

	procedure open(const aparams: array of variant);

	procedure open();

	procedure close;

	procedure clear;

	procedure refresh(const aparams: array of variant);

	procedure refresh;

	procedure next;

	function countrest(): int32;

	function rowsaffected: integer;

	function rowsreturned: integer;

	function asvariant(const aclose: boolean = false): variant;

	function asvariantar(const aclose: boolean = false): variantarty;

	function asvariantarar(const aclose: boolean = false): variantararty;

	procedure loaddatalists(const datalists: array of tdatalist);

Properties

	property datacols: tdbcols read fdatacols;

	property cols[constindex:int32]: tdbcol read getcols write setcols;

	property bof: boolean read fbof;

	property eof: boolean read feof;

	property beforeopen: tmsesqlscript read fbeforeopen write setbeforeopen;

	property afteropen: tmsesqlscript read fafteropen write setafteropen;

	property active: boolean read getactive write setactive default false;

	property fielddefs: tsqlresultfielddefs read ffielddefs write setfielddefs;

	property onbeforeopen: sqlresulteventty read fonbeforeopen write fonbeforeopen;

	property onafteropen: sqlresulteventty read fonafteropen write fonafteropen;

	property params;

	property sql;

	property database;

	property transaction;

	property options;

	property statementtype default stselect;

	property onbeforeexecute;

	property onafterexecute;

	property onerror;

---

Generated by PasDoc 0.16.0.