Hello all. Another weekend - another episode of getting stuck on something I should be able to figure out
I am trying to use Sqlite for a bulk import but for some reason I keep getting the error that it cannot locate the Sqlite3.exe file. I read the help file suggesting it gets stored in the @temp directory. When I read those files I see "sqlite3_300800403.exe" listed amongst them but I don't see "sqlite3.exe" . This may be a dumb question but how can I point _SQLite_SQLiteExe to the sqlite3.exe and should it really be "sqlite3_300800403.exe"?
These are my includes:
#include <SQLite.au3>
#include <SQLite.dll.au3>
This is the generic version of what I am running for the import:
_SQLite_SQLiteExe($sDatabaseFilePath, ".separator ," & @CRLF & ".import '" & FileGetShortName($hImportFilePath) & "' TableName" & @CRLF, $sOutputFile)
Any guidance?