SQLite Examples are not working correctly in AutoIt 3.3.14.3

[AdamUL]

I have been testing AutoIt 3.3.14.3 with SQLite, and the Help File examples.  The examples that I have tested are throwing errors or not doing anything.  I have sqlite3.dll, sqlite3_x64.dll, and sqlite3.exe in the directories with the testing script.  I am copying the examples directly from the help file into a test script for testing with no edits.  The _SQLite_GetTable2d example is returning an error ("Library used incorrectly") with each _SQLite_Exec command.  The _SQLite_FastEncode example returns an empty dialog box.  The _SQLite_Exec example only prints out the SQLite version, and nothing else in the SciTE console.  Currently, I'm still searching for what is causing this issue.  I'm on Windows 7 Enterprise 64-bit.  Is anyone else having this issue?  

 

Adam

 

[TheXman]

Hi Adam -

It's not just you.  I am experiencing some of the same issues with the way that v3.3.14.3 works with SQLite.  I have numerous SQLite scripts and none are working correctly.

From the sqlite functions that are querying the database, I am getting the following sqlite error: $SQLITE_MISUSE = 21 ; /* Library used incorrectly */

[AdamUL]

Using sqlite.au3 from 3.3.14.2 does not cause any major issues, except with previous declared constants errors in some examples.  I just commented out those include constants lines in the examples, and the examples ran without issue.  Something changed in the sqlite.au3 in 3.3.14.3 to cause this issue.  

 

Adam

 

[AdamUL]

I think I have narrow it down a bit.  I don't think it is the sqlite.au3 file, but an issue with one of the includes Array.au3 or File.au3 for 3.3.14.3.  Each sqlite.au3 for 3.3.14.2 and 3.3.14.3, run without issue with 3.3.14.2, that uses 3.3.14.2 Array.au3 and File.au3.  

 

Adam

 

[jpm]

some change occured in _ArraySearch() so it impact the sqlite.au3. I am still working on it.

but if you add _SQLite_SafeMode(True) you certainly go arround.

Sorry for the trouble

[jpm]

The pb comes from the _ArrayAdd() Melba23 is currently fixing it

THe go around avoid to call it so it is a go around

Edited February 3, 2018 by jpm

[Melba23]

Hi guys,

I have posted the amended libraries here:

If you feel brave enough to try replacing the bugged files in your 3.3.14.3 \Include folder with these new versions, can you see if that has fixed the SQLite problem please.

M23

[TheXman]

  On 2/3/2018 at 4:26 PM, Melba23 said:

If you feel brave enough to try replacing the bugged files in your 3.3.14.3 \Include folder with these new versions, can you see if that has fixed the SQLite problem please.

M23

Expand  

I just ran several of my sqlite scripts, with the fixed include files, and they all are running fine now.

Thanks @Melba23!

Edited February 3, 2018 by TheXman
Clarity

[Melba23]

TheXman,

Delighted to hear it - and sorry it happened in the first place. Mea culpa.

M23