Modify

Opened 10 years ago

Closed 10 years ago

Last modified 10 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 Changed 10 years ago by Jpm

  • Resolution set to Works For Me
  • Status changed from new to closed

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

comment:2 Changed 10 years ago by TicketCleanup

  • Milestone 3.3.1.0 deleted

Automatic ticket cleanup.

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.

Add Comment

Modify Ticket

Action
as closed The owner will remain Gary.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.