Skip to content

Instantly share code, notes, and snippets.

@q629988171

q629988171/Simple SQLite Example.au3

Forked from TheDcoder/Simple SQLite Example.au3
Created June 12, 2020 05:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save q629988171/7c7f909e831bba804c8edc52af0d3e22 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save q629988171/7c7f909e831bba804c8edc52af0d3e22 to your computer and use it in GitHub Desktop.
Download ZIP
Simple SQLite Example in AutoIt
Raw
Simple SQLite Example.au3
#include <Array.au3>
#include <SQLite.au3>
_SQLite_Startup() ; Load the DLL
If @error Then Exit MsgBox(0, "Error", "Unable to start SQLite, Please verify your DLL")
Local $sDatabase = @ScriptDir & '\SQLiteTestDatabase.db'
Local $hDatabase = _SQLite_Open($sDatabase) ; Create the database file and get the handle for the database
_SQLite_Exec($hDatabase, 'CREATE TABLE People (first_name, last_name);') ; CREATE a TABLE with the name "People"
_SQLite_Exec($hDatabase, 'INSERT INTO People VALUES ("Timothy", "Lee");') ; INSERT "Timothy Lee" into the "People" TABLE
_SQLite_Exec($hDatabase, 'INSERT INTO People VALUES ("John", "Doe");') ; INSERT "John Doe" into the "People" TABLE
Local $aResult, $iRows, $iColumns ; $iRows and $iColuums are useless but they cannot be omitted from the function call so we declare them
_SQLite_GetTable2d($hDatabase, 'SELECT * FROM People;', $aResult, $iRows, $iColumns) ; SELECT everything FROM "People" TABLE and get the $aResult
_ArrayDisplay($aResult, "Results from the query")
_SQLite_Close($hDatabase)
_SQLite_Shutdown()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment