Description | uses | Classes, Interfaces, Objects and Records | Functions and Procedures | Types | Constants | Variables |
SQLite 3.x object based wrapper
Can be used for object based access to SQLite3 databases.
Note: Requires Sqlite 3.6.8 and higher!
Sample usage:
procedure sample; var database: TSqliteDatabase; tab: TSqliteTable; s: string; begin database := TSqliteDatabase.Create('somedatabase.db3'); try database.AddParamInt(':key', 123456); tab := database.GetTable('SELECT * FROM some_table WHERE ROWID=:key'); try while not tab.EOF do begin s := tab.FieldAsString(tab.FieldIndex['ROWID']); //do something with 'S' variable... //... //...then go to nexr row. tab.next; end; finally tab.free; end; finally database.free; end; end;
Name | Description |
---|---|
Class ESQLiteException |
Exception Class for SQLite based errors |
Class TSQliteParam |
Class for storing deffered parameters |
Class TSQLiteDatabase |
Class for handling SQLite database |
Class TSQLiteTable |
Class for handling SQLite query result |
THookQuery = procedure(Sender: TObject; const SQL: AnsiString) of object; |
THookQuery = procedure(Sender: TObject; const SQL: AnsiString) of object; |
procedural prototype for OnQuery
hook.