AdamUL Posted February 2, 2018 Share Posted February 2, 2018 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 Link to comment Share on other sites More sharing options...
TheXman Posted February 2, 2018 Share Posted February 2, 2018 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 */ CryptoNG UDF: Cryptography API: Next Gen jq UDF: Powerful and Flexible JSON Processor | jqPlayground: An Interactive JSON Processor Xml2Json UDF: Transform XML to JSON | HttpApi UDF: HTTP Server API | Roku Remote: Example Script About Me How To Ask Good Questions On Technical And Scientific Forums (Detailed) | How to Ask Good Technical Questions (Brief) "Any fool can know. The point is to understand." -Albert Einstein "If you think you're a big fish, it's probably because you only swim in small ponds." ~TheXman Link to comment Share on other sites More sharing options...
AdamUL Posted February 2, 2018 Author Share Posted February 2, 2018 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 Link to comment Share on other sites More sharing options...
AdamUL Posted February 2, 2018 Author Share Posted February 2, 2018 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 Link to comment Share on other sites More sharing options...
jpm Posted February 3, 2018 Share Posted February 3, 2018 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 Link to comment Share on other sites More sharing options...
jpm Posted February 3, 2018 Share Posted February 3, 2018 (edited) 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 Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 3, 2018 Moderators Share Posted February 3, 2018 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 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
TheXman Posted February 3, 2018 Share Posted February 3, 2018 (edited) 21 minutes ago, 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 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 CryptoNG UDF: Cryptography API: Next Gen jq UDF: Powerful and Flexible JSON Processor | jqPlayground: An Interactive JSON Processor Xml2Json UDF: Transform XML to JSON | HttpApi UDF: HTTP Server API | Roku Remote: Example Script About Me How To Ask Good Questions On Technical And Scientific Forums (Detailed) | How to Ask Good Technical Questions (Brief) "Any fool can know. The point is to understand." -Albert Einstein "If you think you're a big fish, it's probably because you only swim in small ponds." ~TheXman Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 3, 2018 Moderators Share Posted February 3, 2018 TheXman, Delighted to hear it - and sorry it happened in the first place. Mea culpa. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now