Modify ↓
#840 closed Bug (Works For Me)
_SQlite_Query fails to execute query
Reported by: | ivanperez.x@… | Owned by: | Gary |
---|---|---|---|
Milestone: | Component: | Standard UDFs | |
Version: | 3.3.0.0 | Severity: | Blocking |
Keywords: | _SQlite_Query | Cc: |
Description
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.
Attachments (0)
Change History (2)
comment:1 Changed 16 years ago by Jpm
- Resolution set to Works For Me
- Status changed from new to closed
Guidelines for posting comments:
- You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
- In-depth discussions should take place on the forum.
For more information see the full version of the ticket guidelines here.
Note: See
TracTickets for help on using
tickets.
It is working perfect under standard AutoIt 3.3.0 which is using 3.6.5 _SQlite version