Modify

Opened 17 years ago

Closed 17 years ago

Last modified 17 years ago

#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 by J-Paul Mesnage, 17 years ago

Resolution: Works For Me
Status: newclosed

It is working perfect under standard AutoIt 3.3.0 which is using 3.6.5 _SQlite version

comment:2 by TicketCleanup, 17 years ago

Milestone: 3.3.1.0

Automatic ticket cleanup.

Modify Ticket

Action
as closed The owner will remain Gary.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.