Description | Hierarchy | Fields | Methods | Properties |
type TSqlitePassEngine = class(TObject)
![]() |
Constructor Create(Database: TSqlitePassDatabase); |
![]() |
Destructor Destroy; override; |
![]() |
function CheckResult(i: Integer; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Integer; |
![]() |
function ExecSQL(Const Sql: String; Encode: Boolean = False; CallBackFunc: TSqlitePassExecCallBack = nil): Integer; |
![]() |
function GetLastInsertRowId: Int64; |
![]() |
Function LoadSqliteLibrary(LibraryFile: String): Boolean; |
![]() |
function PrepareStmt(var Stmt: pointer; const sql: String; Encode: Boolean = False; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Boolean; |
![]() |
function UnprepareStmt(var Stmt: pointer): Boolean; |
![]() |
procedure CloseDatabase; |
![]() |
procedure ExecQuery(Const Sql: String; Encode: Boolean = False; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF16(Const Sql: UTF16WideString; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF8(Const Sql: AnsiString; Encode: Boolean = False; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
Procedure FinalizePendingStmts; |
![]() |
procedure OpenDatabase(Const FullName: String; LibraryFile: String = DefaultSQLiteLibrary); |
![]() |
Procedure StartChrono; |
![]() |
Procedure StopChrono; |
![]() |
property Connection: Pointer read FConnectionHandle; |
![]() |
property ElapsedTime: Double read FElapsedTime; |
![]() |
property QueryTimeout: Integer Read FQueryTimeout Write FQueryTimeout; |
![]() |
property Transaction: TSqlitePassTransaction Read FTransaction Write FTransaction; |
![]() |
Constructor Create(Database: TSqlitePassDatabase); |
![]() |
Destructor Destroy; override; |
![]() |
function CheckResult(i: Integer; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Integer; |
![]() |
function ExecSQL(Const Sql: String; Encode: Boolean = False; CallBackFunc: TSqlitePassExecCallBack = nil): Integer; |
————- Sql Exec —————- |
![]() |
function GetLastInsertRowId: Int64; |
![]() |
Function LoadSqliteLibrary(LibraryFile: String): Boolean; |
———— Library —————– |
![]() |
function PrepareStmt(var Stmt: pointer; const sql: String; Encode: Boolean = False; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow): Boolean; |
——– SQL Statements ———– |
![]() |
function UnprepareStmt(var Stmt: pointer): Boolean; |
![]() |
procedure CloseDatabase; |
![]() |
procedure ExecQuery(Const Sql: String; Encode: Boolean = False; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF16(Const Sql: UTF16WideString; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
procedure ExecQueryUTF8(Const Sql: AnsiString; Encode: Boolean = False; VerboseLevel: TSqlitePassVerboseLevel = vlLogAndShow); |
![]() |
Procedure FinalizePendingStmts; |
![]() |
procedure OpenDatabase(Const FullName: String; LibraryFile: String = DefaultSQLiteLibrary); |
————- Database —————- |
![]() |
Procedure StartChrono; |
Chrono |
![]() |
Procedure StopChrono; |
![]() |
property Connection: Pointer read FConnectionHandle; |
![]() |
property ElapsedTime: Double read FElapsedTime; |
![]() |
property QueryTimeout: Integer Read FQueryTimeout Write FQueryTimeout; |
![]() |
property Transaction: TSqlitePassTransaction Read FTransaction Write FTransaction; |
Transactions. TODO : Rework on nested named transactions. Sqlite engine supports only one active |