BigDaddyO Posted February 6, 2018 Share Posted February 6, 2018 I just upgraded to the new 3.3.14.3 yesterday and I am testing out my scripts that use SQLite since that had a change. I can't seem to get even the simplest of scripts to work now. I keep getting an error 2 with any Query. I still have a standalone version of the 3.3.14.2 where this script works fine. Any idea what needs to be changed to get this to work in the new version? I even downloaded the most recent sqlite3.dll file from the link provided in the new help file. expandcollapse popup#include <SQLite.au3> FileInstall(".\Includes\SQlite3.dll", @TempDir & "\SQlite3.dll", 1) $sMaskConn = @ScriptDir & "\SQLite_Test.db" ;Connect to the SQLite Db _SQLite_Startup(@TempDir & "\SQlite3.dll", False, 1) If @error Then ConsoleWrite("Error " & @error & " while connecting to SQLite database" & @CRLF) Exit EndIf $hMaskDB = _SQLite_Open($sMaskConn, $SQLITE_OPEN_READWRITE) If @error Then ConsoleWrite("SQLite Open Error = " & @error & ", Extended = " & @extended & @CRLF) Exit EndIf ;Find any records with missing data $sSQLite = "Select MaskID, Start_Dt from MaskData where ProdID is NULL" Local $hQueryRet, $aRow, $sMissingID, $aMissingID[0][2] _SQLite_Query($hMaskDB, $sSQLite, $hQueryRet) If @error Then ConsoleWrite("Query generated error " & @error & @CRLF) Exit EndIf While _SQLite_FetchData($hQueryRet, $aRow) = $SQLITE_OK If $sMissingID = "" Then $sMissingID = $aRow[0] & "|" & $aRow[1] Else $sMissingID &= @CRLF & $aRow[0] & "|" & $aRow[1] EndIf WEnd _SQLite_QueryFinalize($hQueryRet) _ArrayAdd($aMissingID, $sMissingID, 0, "|", @CRLF) _ArrayDisplay($aMissingID, "Missing ID's") Attached the simple .db that i built for this sample script. SQLite_Test.db Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted February 6, 2018 Moderators Share Posted February 6, 2018 BigDaddyO, It is a problem in _ArrayAdd - mea culpa. It is already fixed and you can download and replace the Array library as explained here: 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...
BigDaddyO Posted February 6, 2018 Author Share Posted February 6, 2018 Thanks Melba, Replacing those two files fixed it. 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