Sqlite Beginner

[thegoodguy]

HI there,

I want perform various analyses on my Firefox downloads. I hunted for where I could find all the data and found that Firefox stores it in a database (downloads.sqlite).

I am fairly new to Autoit and totally new to Sqlite.

I read a little about sqlite, I opened the example script on the "_SQLite_Startup" Autoit help file page and ran it. I get the error "SQLite3.dll Can't be Loaded!". I am guessing I don't have some files that I should have, but I can't figure out what's missing.

I have installed the lastest version of Autoit and downloaded SQLite.dll.au3 and SQLite3.dll from http://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/.

If someone can get me pointed in the right direction it'd be much appreciated.

Many thanks.

[kylomas]

thegoodguy,

SQLite attempts to find sqlite3.dll in the following directories:

@scriptdir

@windowsdir

@systemdir

@workingdir

Copy the dll to one of them and the example should work.

You can see what each of these values are on your machine with the following code

consolewrite(@scriptdir & @lf & @windowsdir & @lf & @systemdir & @lf & @workingdir & @lf)

kylomas

[thegoodguy]

Thanks kylomas.

Now on to the next hurdle ...