jonny1234 Posted November 9, 2006 Share Posted November 9, 2006 Hi, I am currently evaluating the use of SQLite with AutoIt. I keep getting an "unable to execute DllCall" fatal crash at line 630 of SQLite.au3 (function_SQLite_GetTable2d): DllCall($g_hDll_SQLite, "none:cdecl", "sqlite3_free_table", "ptr", $pResult); pointer to 'resultp' from sqlite3_get_table I am repeatedly calling _SQLite_QuerySingleRow (which calls _SQLite_GetTable2d) within a loop to retrieve records by their ID from a database, and adding the results to a list view. Most of the time it works, but sometimes it fails with the above error, and it doesn't always fail at the same point. When calling _SQLite_QuerySingleRow repeatedly, I am re-using the same variable for the $aRow parameter. Do I have to initialize it in a particularly way between calls? Or is there a problem with SQLite.au3? Please can you help. Regards, Jonny Link to comment Share on other sites More sharing options...
jonny1234 Posted November 9, 2006 Author Share Posted November 9, 2006 Within the same loop, I'm now also getting a fatal crash at line 568 of SQLite.au3, which again is in _SQLite_GetTable2d: $r = DllCall($g_hDll_SQLite, "int:cdecl", "sqlite3_get_table", _ "ptr", $hDB, _; An open database "str", $sSQL, _; SQL to be executed "long_ptr", 0, _; Result written to a char *[] that this points to "long_ptr", 0, _; Number of result rows written here "long_ptr", 0, _; Number of result columns written here "long_ptr", 0) ; Error msg written here Any ideas? Regards, Jonny Link to comment Share on other sites More sharing options...
ptrex Posted November 10, 2006 Share Posted November 10, 2006 @jonny1234 Best way to get it solved is to sent a PM to the developer of the SQLite.au3 Including your code !! His name is "piccaso" see post in Scripts and Scraps. Regards ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New 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