Error using SQLite.au3

[willichan]

I am getting the following error when I try to run a script that includes SQLite.au3 that came with AI 3.3.8.1.

C:\Program Files (x86)\AutoIt3\Include\SQLite.au3(2,13) : ERROR: missing separator character after keyword.
#IgnoreFunc __SQLite_Inline_Version
~~~~~~~~~~~~^
C:\test\test.au3 - 1 error(s), 0 warning(s)

and the following in the SCITE console

>"C:\Program Files (x86)\AutoIt3\SciTE\AutoIt3Wrapper\AutoIt3Wrapper.exe" /run /prod /ErrorStdOut /in "C:\test\test.au3" /UserParams  
+>21:21:08 Starting AutoIt3Wrapper v.2.1.0.8    Environment(Language:0409  Keyboard:00000409  OS:WIN_7/Service Pack 1  CPU:X64 OS:X64)
>Running AU3Check (1.54.22.0)  from:C:\Program Files (x86)\AutoIt3
C:\Program Files (x86)\AutoIt3\Include\SQLite.au3(2,13) : ERROR: missing separator character after keyword.
#IgnoreFunc __SQLite_Inline_Version
~~~~~~~~~~~~^
C:\test\test.au3 - 1 error(s), 0 warning(s)
!>21:21:08 AU3Check ended.rc:2

Using the following test code

expandcollapse popup

Opt("MustDeclareVars", 1)
Opt("TrayAutoPause",   0)
Opt("TrayMenuMode", 0)
Opt("TrayIconHide", 0)
Global Const $MyName=StringLeft(@ScriptName, StringInStr(@ScriptName,".", 0, -1)-1)
Global Const $MyMutex=$MyName & "-326647042B70D5BD"
Global $SQLloaded = False
If _MutexExists($MyMutex) Then Exit
#include <SQLite.au3>

_ConfigInitialize()

Func _ConfigInitialize()
Local $msg, $sql
Global $dbName = @AppDataCommonDir & "\testdata\testdata.db"
If Not FileExists(@AppDataCommonDir & "\testdata") Then DirCreate(@AppDataCommonDir & "\testdata")
OnAutoItExitRegister("_ConfigDestroy")
If Not FileExists(@TempDir & "\sqlite3.dll") Then FileInstall("sqlite3.dll", @TempDir & "\sqlite3.dll")
Global $sSQliteDll = _SQLite_Startup(@TempDir & "\sqlite3.dll")
Global $sSQLiteDB = _SQLite_Open($dbName)
$SQLloaded =True
$msg  = "CREATE TABLE IF NOT EXISTS test ("
$msg &= "data1 varchar(10), "
$msg &= "data2 real, "
$msg &= "data3 integer, "
$msg &= "PRIMARY KEY (data1)"
$msg &= ");"
$sql = _SQLite_Exec($sSQLiteDB, $msg)
If @error Then MsgBox(0,@ScriptName,"error creating table: test [" & $sql & "]")
EndFunc  ;==>_ConfigInitialize
Func _ConfigDestroy()
If $SQLloaded Then
  _SQLite_Close()
  _SQLite_Shutdown()
EndIf
EndFunc  ;==>_ConfigDestroy

Func _MutexExists($sOccurenceName)
    Local $ERROR_ALREADY_EXISTS = 183, $handle, $lastError
    $sOccurenceName = StringReplace($sOccurenceName, "\", "")
    $handle = DllCall("kernel32.dll", "int", "CreateMutex", "int", 0, "long", 1, "str", $sOccurenceName)
    $lastError = DllCall("kernel32.dll", "int", "GetLastError")
    Return $lastError[0] = $ERROR_ALREADY_EXISTS
EndFunc  ;==>_MutexExists

I saw a proposed workaround for someone with the same error message, but since I am not using guilistview, and have no other includes in my script, I am at a loss. Any suggestions?

[PhoenixXL]

Try Opening

C:Program Files (x86)AutoIt3IncludeSQLite.au3

and Delete the Line

#IgnoreFunc __SQLite_Inline_Version

see if that helps

Regards

Phoenix XL

Edited June 6, 2012 by PhoenixXL

[willichan]

That does seem to get rid of the error.

The #ignorefunc directive is kind of glossed over in the help file, so I wasn't sure the ramifications of altering that line.

Everything appears to be working for both the above script, and the full script I am working on, so all is good.

Thank you.

[jchd]

The error doesn't show when using the beta.

[willichan]

I'll give it a try tonight with the latest beta. I prefer that to modifying the UDF.

--Edit--

Worked fine with the latest beta. Thanks for the help.

Edited June 7, 2012 by willichan