Class TSDDatabase (unit SDEngine)

Inherits from

TComponent

Constructors


constructor Create(AOwner: TComponent);

TSDDatabase


Functions

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);


Properties

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


Events

event OnLogin : TSDLoginEvent


Variables

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;



Constructors


constructor Create(AOwner: TComponent);

TSDDatabase


Functions


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);


Properties


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


Events


event OnLogin : TSDLoginEvent


Variables


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;