﻿id	summary	reporter	owner	description	type	status	milestone	component	version	severity	resolution	keywords	cc
2635	Sqlite don't work with windows 2008 R2	raclius@…		"Hi,
I have a strange behavior between sqlite and Windows 2008 R2

'''Sample of Autoit CHM :'''

#include <SQLite.au3>
#include <SQLite.dll.au3>
#include <MsgBoxConstants.au3>

Local $hQuery, $aRow, $sMsg
_SQLite_Startup()
ConsoleWrite(""_SQLite_LibVersion="" & _SQLite_LibVersion() & @CRLF)
_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($MB_SYSTEMMODAL, ""SQLite"", ""Get Data using a Query : "" & $sMsg)
_SQLite_Close()
_SQLite_Shutdown()

; Output:
; ;~ Hello World



'''This sample of Autoit don't work and return :'''

_SQLite_LibVersion=0
""F:\ObotAnalogs\New AutoIt v3 Script.au3"" (26) : ==> Subscript used on non-accessible variable.:
MsgBox(0, ""One of the values for key > 2:"", $aRow[0])
MsgBox(0, ""One of the values for key > 2:"", $aRow^ ERROR

'''I have lot of scripts with sqlite who works in XP or Seven but no under Windows 2008 R2'''

'''Best regards
Mehdi'''"	Bug	closed		AutoIt	3.3.10.2	None	No Bug		
