Unit SQLiteWrap

DescriptionusesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

Description

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;

Overview

Classes, Interfaces, Objects and Records

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

Types

THookQuery = procedure(Sender: TObject; const SQL: AnsiString) of object;

Description

Types

THookQuery = procedure(Sender: TObject; const SQL: AnsiString) of object;

procedural prototype for OnQuery hook.


Generated by PasDoc 0.9.0 on 2009-06-16 13:42:34