id	summary	reporter	owner	description	type	status	milestone	component	version	severity	resolution	keywords	cc
840	_SQlite_Query fails to execute query	ivanperez.x@…	Gary	"From the example in the help file this should output Hello World

{{{
#include <SQLite.au3>
#include <SQLite.dll.au3>

Local $hQuery, $aRow, $sMsg
_SQLite_Startup ()
ConsoleWrite(""_SQLite_LibVersion="" &_SQLite_LibVersion() & @CR)
_SQLite_Open () ; open :memory: Database
_SQLite_Exec (-1, ""CREATE TABLE aTest (a,b,c);"") ; CREATE a Table
_SQLite_Exec (-1, ""INSERT INTO aTest(a,b,c) VALUES ('c','2','World');"") ; INSERT Data
_SQLite_Exec (-1, ""INSERT INTO aTest(a,b,c) VALUES ('b','3',' ');"") ; INSERT Data
_SQLite_Exec (-1, ""INSERT INTO aTest(a,b,c) VALUES ('a','1','Hello');"") ; INSERT Data
_SQlite_Query (-1, ""SELECT c FROM aTest ORDER BY a;"", $hQuery) ; the query
While _SQLite_FetchData ($hQuery, $aRow) = $SQLITE_OK
    $sMsg &= $aRow[0]
WEnd
_SQLite_Exec (-1, ""DROP TABLE aTest;"") ; Remove the table
MsgBox(0,""SQLite"",""Get Data using a Query : "" &  $sMsg )
_SQLite_Close()
_SQLite_Shutdown()
}}}

I suppose this is due to a change in the sqlite version to 3.3.7, whereas in the previous release of autoit it used to be 3.4.0. Other functions may also be failing in this UDF. I'll check them out, but prior to this I want to make sure this is a real bug."	Bug	closed		Standard UDFs	3.3.0.0	Blocking	Works For Me	_SQlite_Query