| Class TSQLQuery (unit MSSQL) |
TObject
| Constructors |
constructor Create(aSession : TSQLSession);| Functions |
procedure Close;
destructor Destroy;
procedure ExecSQL;
procedure ExecSQLEx(aSQL : String; IgnoreException : Boolean);
function First : Boolean;
function Last : Boolean;
function MoveBy(Row : Integer) : Boolean;
function MoveTo(Row : Integer) : Boolean;
function Next : Boolean;
procedure Open(bReadOnly : Boolean; OnGetSQLData : TOnGetSQLData);
function Previous : Boolean;
function GetActive : Boolean;
function GetBOF : Boolean;
function GetEOF : Boolean;
function GetFieldByIndex(Index : Integer) : TField;
function GetFieldByName(Name : String) : TField;
function GetHandle : PDBPROCESS;
function GetRowNumber : Integer;
procedure SetActive(Data : Boolean);| Properties |
property Active : Boolean
property BOF : Boolean
property ColCount : Integer
property EOF : Boolean
property FieldByName : TField
property Fields : TField
property Handle : PDBPROCESS
property RowCount : Integer
property RowNumber : Integer
property Session : TSQLSession
property SQL : TSQLList
property State : TSQLState| Events |
| Variables |
fColCount : Integer;
fErrCode : Integer;
fFields : TList;
fRowCount : Integer;
fRowNumber : Integer;
fSession : TSQLSession;
fSQL : TSQLList;
fState : TSQLState;| Constructors |
constructor Create(aSession : TSQLSession);| Functions |
procedure Close;
destructor Destroy;
procedure ExecSQL;
procedure ExecSQLEx(aSQL : String; IgnoreException : Boolean);Da SQL-Abfragen, die mit ExecSQL ausgefuehrt werden, keine Er- *) (* gebnisse bringen sollten, kann das warten auf ein Ergebnis mit *) (* dbcancel angebrochen werden. Wird diese Funtkion nicht aufge- *) (* rufen, so erwartet das System ein Abholen des Ergebnisses.
function First : Boolean;
function Last : Boolean;
function MoveBy(Row : Integer) : Boolean;
function MoveTo(Row : Integer) : Boolean;
function Next : Boolean;
procedure Open(bReadOnly : Boolean; OnGetSQLData : TOnGetSQLData);
function Previous : Boolean;
function GetActive : Boolean;
function GetBOF : Boolean;
function GetEOF : Boolean;
function GetFieldByIndex(Index : Integer) : TField;
function GetFieldByName(Name : String) : TField;
function GetHandle : PDBPROCESS;
function GetRowNumber : Integer;
procedure SetActive(Data : Boolean);TSQLQuery ----------------------------------------------------------
| Properties |
property Active : Boolean
property BOF : Boolean
property ColCount : Integer
property EOF : Boolean
property FieldByName : TField
property Fields : TField
property Handle : PDBPROCESS
property RowCount : Integer
property RowNumber : Integer
property Session : TSQLSession
property SQL : TSQLList
property State : TSQLState| Events |
| Variables |
fColCount : Integer;Anzahl der Ergebnissaetze
fErrCode : Integer;
fFields : TList;Anzahl der Spalten der SQl-Statements
fRowCount : Integer;0 basierend
fRowNumber : Integer;Zugehoerige Session
fSession : TSQLSession;
fSQL : TSQLList;Fehlerflag => SUCCESS = 0
fState : TSQLState;Liste der Spalten eines SQL-Statements