Custom Query (3926 matches)

I have a scheduled task that uses _GUICtrlListView_ClickItem Working phisically on the pc, the scheduled task works as expected. Connecting in remote desktop, if the scheduled task runs while the user is still in remote desktop, the scheduled task works as expected. However, connecting in remote desktop, then closing the remote desktop (without disconnecting the user), the scheduled task does not work (the function _GUICtrlListView_ClickItem does not click on the list item). If I connect again phisically , the task works again. Tested with AutoIt latest version.

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

_GUICtrlRichEdit_StreamToVar $iOpts [optional] additional options:

$SFF_PLAINTRTF - write only rich text keywords common to all languages

Should be: $SFF_PLAINRTF ... (there's a spurious T)

I know this is a small thing, but it cost me 20 minutes to find.