AutoIT Script Tutorial | Connecting SQLite Database with AutoIt Script Tutorial Part #1
In this tutorial session we will interact with sqlite database with autoit script. We are going to do following action items in this tutorial. Let's do it together-
Note: we can create 3 types of sqlite database as per our requirement.
1) Creating a :memory: database
2) Creating a temporary disk database
3) Creating a permanent disk database
Note - To avoid "sqlite3.dll "SQLite3.dll Can't be Loaded!" Error -
Prerequisites : we need to download latest 'SQLite.dll.au3' and replace the old one. Please follow my instructions...
Step 1: Run "AutoSQLiteUpdateIt.au3" script from below path:
C:\Program Files (x86)\AutoIt3\Extras\AutoUpdateIt
now go to this location and copy "SQLite.dll.au3":
C:\Users\MacWin\AppData\Local\AutoIt v3\SQLite
Step 2: now we replace old 'SQLite.dll.au3' file with newly downloaded file.
here is the path : C:\Program Files (x86)\AutoIt3\Include
Step 3: Verify -- open autoit Script editor and run following lines of code.
Action Item 1 - Now we Create a memory database:
==========================================
_SQLite_Startup()
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!")
Exit -1
EndIf
ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF)
_SQLite_Open() ; Creates a :memory: database and don't use its handle to refer to it
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a memory Database!")
Exit -1
EndIf
_SQLite_Close()
----------------------------------------------------------------------------------------------------------------
Action Item 2 - Now we Create a temporary disk database:
========================================================
Local $hTmpDb = _SQLite_Open('') ; Creates a temporary disk database
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a temporary Database!")
Exit -1
EndIf
----------------------------------------------------------------------------------------------------------------
Action Item 3 - Now we Create a Permanent disk database:
========================================================
Local $sDbName = _TempFile()
Local $hDskDb = _SQLite_Open($sDbName) ; Open a permanent disk database
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't open or create a permanent Database!")
Exit -1
EndIf
----------------------------------------------------------------------------------------------------------------
; we can use the 3 database as needed by refering to their handle
; close the Dbs we created, in any order
_SQLite_Close($hTmpDb) ; temporary database are deleted automatically at Close
_SQLite_Close($hDskDb) ; DB is a regular file that could be reopened later
_SQLite_Close($hMemDb)
; we don't really need that DB
FileDelete($sDbName)
_SQLite_Shutdown()
If _SQLite_Startup() failed or was not executed, an AutoIt runtime error will be thrown, and the script will terminate!
AutoIt automatically closes any dlls it opened, but calling _SQLite_Shutdown() is still a good idea.
#AutoItConnectSQliteDatabase #coolithelp
En esta página del sitio puede ver el video en línea AutoIT Script Tutorial | Connecting SQLite Database with AutoIt Script Tutorial Part #1 de Duración hora minuto segunda en buena calidad , que subió el usuario Cool IT Help 13 octubre 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,686 veces y le gustó 13 a los espectadores. Disfruta viendo!
