Hi,
Great script , thanks for sharing
I ran the script and created the SQLite.dll.au3 file , and included it in my script
but im still getting error "SQLite3.dll Can't be Loaded!"
I will really appreciate it if you took a look at my code below
Thanks
#include <SQLite.au3>
#include <SQLite.dll.au3>
_SQLite_Startup()
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!")
Exit -1
EndIf
$DB = _SQLite_Open("C:\Temp\Test.db")
$Action = "TestAction"
$Time = @HOUR&":"&@MIN&":"&@SEC
$Date = @YEAR&"-"&@MON&"-"&@MDAY
$User = @UserName
$Computer = @ComputerName
$DC = @LogonServer
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Couldnt open Database")
Exit -1
EndIf
_SQLite_Exec($DB,"INSERT INTO QLogs (Action,Date,Time,User,Computer,DC) " & _
"VALUES ("& _SQLite_FastEscape($Action) & "," & _
_SQLite_FastEscape($Date) & "," & _
_SQLite_FastEscape($Time) & "," & _
_SQLite_FastEscape($User) & "," & _
_SQLite_FastEscape($Computer) & "," & _
_SQLite_FastEscape($DC) & ");")
If @error Then
MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Couldnt insert!")
Exit -1
EndIf
_SQLite_Shutdown()