Class TSDDatabase (unit SDEngine) |
Inherits from
TComponent
constructor Create(AOwner: TComponent);
- TSDDatabase
procedure Close;
procedure CloseDatasets;
procedure Commit;
destructor Destroy;
procedure Open;
procedure Rollback;
procedure StartTransaction;
procedure AllCursorContextDestroy;
procedure CursorContextDestroy(DoCommit: Boolean);
True - if a cursor context destroys by execute Commit, otherwise False (for example, Rollback
procedure CheckActive;
procedure CheckInactive;
function GetConnected: Boolean;
Cursor context stored after run ROLLBACK only for isolation level equal 'RL'
function GetDataSet(Index: Integer): TSDDataSet;
function GetDataSetCount: Integer;
function GetIsSQLBased: Boolean;
procedure Login(LoginParams: TStrings);
procedure SetConnected(Value: Boolean);
procedure SetDatabaseName(const Value: TFileName);
procedure SetKeepConnection(Value: Boolean);
procedure SetNullIndicatorError(Value: Boolean);
Set NULL indicator parameter for cursor
procedure SetParameters;
procedure SetParams(Value: TStrings);
procedure SetRemoteDatabase(Value: TSqlLoginStr);
procedure SetSqlResult(Value: SqlTRcd);
procedure SetTransIsolation(Value: TSDTransIsolation);
property Connected : Boolean
property DatabaseName : TFileName
property KeepConnection : Boolean
property LoginPrompt : Boolean
property Params : TStrings
property RemoteDatabase : TSqlLoginStr
property TransIsolation : TSDTransIsolation
property DataSetCount : Integer
property DataSets : TSDDataSet
property Handle : hSqlCursor
property IsSQLBased : Boolean
property Temporary : Boolean
property SqlResult : SqlTRcd
event OnLogin : TSDLoginEvent
FActiveTrans : Boolean;
FDatabaseName : TFileName;
FDataSets : TList;
FHandle : hSqlCursor;
FKeepConnection : Boolean;
FLoginPrompt : Boolean;
FOnLogin : TSDLoginEvent;
FParams : TStrings;
FRefCount : Integer;
FRemoteDatabase : TSqlLoginStr;
FSqlResult : SqlTRcd;
FSrvName : TSqlLoginStr;
FStreamedConnected : Boolean;
FTemporary : Boolean;
return code of C/API function
FTransIsolation : TSDTransIsolation;
constructor Create(AOwner: TComponent);
TSDDatabase
procedure Close;
procedure CloseDatasets;
procedure Commit;
destructor Destroy;
procedure Open;
procedure Rollback;
procedure StartTransaction;
procedure AllCursorContextDestroy;
procedure CursorContextDestroy(DoCommit: Boolean);
True - if a cursor context destroys by execute Commit, otherwise False (for example, Rollback
procedure CheckActive;
procedure CheckInactive;
function GetConnected: Boolean;
Cursor context stored after run ROLLBACK only for isolation level equal 'RL'
function GetDataSet(Index: Integer): TSDDataSet;
function GetDataSetCount: Integer;
function GetIsSQLBased: Boolean;
procedure Login(LoginParams: TStrings);
procedure SetConnected(Value: Boolean);
procedure SetDatabaseName(const Value: TFileName);
procedure SetKeepConnection(Value: Boolean);
procedure SetNullIndicatorError(Value: Boolean);
Set NULL indicator parameter for cursor
procedure SetParameters;
procedure SetParams(Value: TStrings);
procedure SetRemoteDatabase(Value: TSqlLoginStr);
procedure SetSqlResult(Value: SqlTRcd);
procedure SetTransIsolation(Value: TSDTransIsolation);
property Connected : Boolean
property DatabaseName : TFileName
property KeepConnection : Boolean
property LoginPrompt : Boolean
property Params : TStrings
property RemoteDatabase : TSqlLoginStr
property TransIsolation : TSDTransIsolation
property DataSetCount : Integer
property DataSets : TSDDataSet
property Handle : hSqlCursor
property IsSQLBased : Boolean
property Temporary : Boolean
property SqlResult : SqlTRcd
event OnLogin : TSDLoginEvent
FActiveTrans : Boolean;
FDatabaseName : TFileName;
FDataSets : TList;
FHandle : hSqlCursor;
FKeepConnection : Boolean;
FLoginPrompt : Boolean;
FOnLogin : TSDLoginEvent;
FParams : TStrings;
FRefCount : Integer;
FRemoteDatabase : TSqlLoginStr;
FSqlResult : SqlTRcd;
FSrvName : TSqlLoginStr;
FStreamedConnected : Boolean;
FTemporary : Boolean;
return code of C/API function
FTransIsolation : TSDTransIsolation;