Broadcastic Posted December 23, 2011 Share Posted December 23, 2011 I just got a new laptop with Windows 7 64 bit and moving my Autoit projects from XPI downloaded SQLite.au3 here and also got a new BetaStill I get an error while using _SQLite_QuerySingleRowerror code is 21 - I belive it is "Library is used incorrectly"WTF?! and how to fix it? Link to comment Share on other sites More sharing options...
jchd Posted December 23, 2011 Share Posted December 23, 2011 Humm, hard to tell from where I live. Wouldn't you by chance be mixing 64-bit AutoIt and 32-bit sqlite library? This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
Broadcastic Posted December 23, 2011 Author Share Posted December 23, 2011 (edited) i just used Run Script(x86) - I get the same error, same line Edited December 23, 2011 by Broadcastic Link to comment Share on other sites More sharing options...
Zedna Posted December 23, 2011 Share Posted December 23, 2011 (edited) I just checked on Win7 64bit example script from 3.3.7.23 beta helpfile for _SQLite_QuerySingleRow() and it works fine on latest beta 3.3.7.23. Post your small reproducing script to get more help. Also check where is sqlite3.dll on your system and if it's "_x64". EDIT: also try to use #AutoIt3Wrapper_UseX64=n Edited December 23, 2011 by Zedna Resources UDF Â ResourcesEx UDF Â AutoIt Forum Search Link to comment Share on other sites More sharing options...
Broadcastic Posted December 24, 2011 Author Share Posted December 24, 2011 (edited) Also check where is sqlite3.dll on your system and if it's "_x64". Yes I found one in Windows/system32 directory, did try to rename it and it re-copies itself again IS THIS HOW W7 BEHAVES? sqlite3_x64.dll Run beta agin C:\Program Files (x86)\AutoIt3\Beta\Includesqlite.au3(2,13) : ERROR: missing separator character after keyword. #IgnoreFunc __SQLite_Inline_Version ~~~~~~~~~~~~^ Edited December 24, 2011 by Broadcastic Link to comment Share on other sites More sharing options...
jchd Posted December 24, 2011 Share Posted December 24, 2011 (edited) There must be something gone wrong in your installation.Since the 3.3.8.0 release is now out, you should remove the beta then the old release and install v3.3.8.0. After those steps your install should be fine.If you experience further problem, please post a small reproducer script (within AutoIt tags, the blue square icon) and also the whole content of the Scite console showing what happened. If the issue vanish, then say so.I've asked a Mod to move this thread in the General Help forum where it belongs.Edit: thread moved, thanks Jos.Edit 2: also check Edited December 24, 2011 by jchd This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
Broadcastic Posted December 26, 2011 Author Share Posted December 26, 2011 Yes, it worked. I uninstalled old and installed 3.3.8.0 releaseThank you!btw when I was installing 3.3.8.0 it defaulted to Program files (x86) folderwhile compiler was looking at Program files'C:program' is not recognized as an internal or external command,operable program or batch file. Link to comment Share on other sites More sharing options...
jchd Posted December 27, 2011 Share Posted December 27, 2011 Glad to know you finally have it working. Those pesky x64 details are annoying but I can't test x64 here. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
t0nZ Posted January 2, 2012 Share Posted January 2, 2012 (edited) I resolved ... but why?take a look at this thread, my post : Edited January 2, 2012 by t0nZ Link to comment Share on other sites More sharing options...
jchd Posted January 2, 2012 Share Posted January 2, 2012 Replied there. This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) 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