Skip to content
AHK SQLite API wrapper class
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.
Sources_v1.1 Update Jul 12, 2019
.gitattributes Initial commit Dec 20, 2013
.gitignore Initial commit Dec 20, 2013
LICENSE Create LICENSE Aug 23, 2014 Update Aug 25, 2015


AHK SQLite API Wrapper

AHK class providing support to access SQLite databases.

Additional stuff

Basic usage

  • Create a new instance of the class SQLiteDB calling MyDB := New SQLiteDB
  • Open your database calling MyDB.OpenDB(MyDatabaseFilePath). If the file doesn't exist, a new database will be created unless you specify "False" as the third parameter.
  • MyDB object provides four methods to pass SQL statements to the database:
    • MyDB.Exec(SQL)
      Should be called for all SQL statements which don't return values from the database (e.g. CREATE, INSERT, UPDATE, etc.).
    • MyDB.GetTable(SQL, Table, ...)
      Should be called for SELECT statements whenever you want to get the complete result of the query as a "Table" object for direct access via the row index. All field values will be returned "in their zero-terminated string representation" (and accordingly an empty string for NULL values).
    • MyDB.Query(SQL, RecordSet, ...)
      Should be called for SELECT statements whenever you want to get the result of the query as a "RecordSet" object. You'll have to call the built-in method RecordSet.Next() to access the records sequentially. Only DB-Query() does handle BLOBs properly. All other field types will be returned as strings (see DB.GetTable()). If you don't need the RecordSet anymore, call RecordSet.Free() to release the resources.
    • MyDB.StoreBLOB(SQL, BlobArray)
      Should be called whenever BLOBs shall be stored in the database. For each BLOB in the row you have to specify a ? parameter within the statement. The parameters are numbered automatically from left to right starting with 1. For each parameter you have to pass an object within BlobArray containing the address and the size of the BLOB.
  • After all work is done, call MyDB.CloseDB() to close the database. For all still existing queries RecordSet.Free() will be called internally.
  • For further details look at the inline documentation in the class script and the sample scripts, please.
You can’t perform that action at this time.