3.3.8.0 SQLite problem

[veronesi]

Hi there

I just downloaded the 3.3.8.0, uninstalled all previous installed AutoIt Versions and installed the new 3.3.8.0!

Now I just have a problem using all SQLite commands.

The SQLite_Startup fails, because it can't find any DLL.

In the SQLite.dll.au3 there is no data for a DLL.

Am I missing something?

What do I have to do that I can use the SQLite commands again?

(Sorry for my bad english)

Thanks in advance

Veronesi

; -----------------------------------------

Edit: I added SQLite to the title so the right people will look at the topic. M23

Edited December 24, 2011 by Melba23
Title clarity

[water]

IIRC there was a discussion about SQLite and 3.3.8.0. You have to download SQLite yourself.

I will post the link as soon as I find the thread.

Edit:

Edited December 24, 2011 by water

[veronesi]

Hi Water

Thanks for your reply.

Do I need the x64 version of the DLL, when I compile the Script as X86 but use it on a X64 computer?

Or only the X86?

Thanks!

Veronesi

[jchd]

No use the 32-bit version (sqlite3.dll) for x86 builds, the 64-bit version (sqlite3_x64.dll) for x64 builds.

You can download the up-to-date DLLs from the AutoIt download directory for SQLite.

Edit:

There are currently two SQLite DLL releases in the repository. One is v3.7.2 without FTS and RTREE support compiled. The other is the latest 3.7.9 with both FTS and RTEE support. The files without an explicit version number are copies of this latest version (now 3.7.9).

For those who wonder which SQLite version to download and use, here's what I recommend: get the copies without version number, they are up-to-date and include these useful extensions.

Download only once the 32- and/or 64-bit DLL depending on your intention to use x86 and/or x64 and store it/them in a fixed place.

Then pass the DLL name to _SQLite_Startup and set ForceLocal to 1. That will make you sure that you use the right DLL and also will prevent any downloading of the obsolete and less complete 3.7.2 version. The reason is that the automated download targets v3.7.2 file(s) instead of the copy without version string.

That should work (I don't have the possibility to test it right now).

FileInstall the DLL if you need to distribute the application to avoid loading the repository.

Edited December 24, 2011 by jchd

[veronesi]

Hi Water, Hi jchd

Thank you very much for you replies!

Best regards

Veronesi

[jchd]

I've just edited my post above while you replied!

[veronesi]

OK!

Thanks!

[t0nZ]

I had this problem :

C:\Program Files (x86)\AutoIt3\Beta\Includesqlite.au3(2,13) : ERROR: missing separator character after keyword.

#IgnoreFunc __SQLite_Inline_Version

in a old program when i tried to compile with V 3.3.8 .

But the only way I resolved is to move the #include <SQLite.au3> in the first position among my includes:

#Region ;**** Directives created by AutoIt3Wrapper_GUI ****
#AutoIt3Wrapper_Icon=Iconeairelemental.ico
#AutoIt3Wrapper_UseX64=n
#EndRegion ;**** Directives created by AutoIt3Wrapper_GUI ****
; aRIA  -> a.dvanced R.apporto I.nterventi A.genti
#include <SQLite.au3>   ; this include and..
#include <SQLite.dll.au3>  ; and this moved here from version 3.3.8
;include da Koda
#include <ButtonConstants.au3>
#include <ComboConstants.au3>
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>
#include <GuiListView.au3>
;include da NSC
;#include <SQLite.au3>   ; this include and..
;#include <SQLite.dll.au3>  ; and this moved UP from version 3.3.8
#include <date.au3>
#include <GuiTab.au3>
#include <Google Maps.au3>
#include <INet.au3>
#include <DateTimeConstants.au3>
#include <_SQL.au3>   ; lo uso per la prima volta nella funzione importautenti()
#include <GuiDateTimePicker.au3> ;uso anche le ore/minuti negli interventi

why ? why? why?

[jchd]

The SQLite UDF is not the culprit here.

The issue is with ExitLoop at line 7112 of GuiListView. Due to a bug already reported (#2073) you need to insert any dummy instruction there.

For instance, insert "Local $Dummy" at line 7113 of GuiListView.au3

[t0nZ]

Tested with modified UDF with dummy instruction and OK.

But for now I assume this is the (unofficial or official) solution ?

Thanx.

[trancexx]

Workarounds are unacceptable as official solutions.