isnull / ahkdba Goto Github PK

Just upgraded to sqlite3.dll version 3.14.1

However this throws an exception as the "minimum version" compare think the dll is version 3.1.

https://github.com/IsNull/ahkDBA/blob/master/Lib/SQLite_L.ahk#L112

just commented the lines, and it works.

However, a better verification of version number should be implemented.

I am trying to execute a procedure in a loop. The first call works, but then the error happens.
I tried searching something to fix the problem, but I did not succeed.
I know you do not get any more maintenance on this project, but if anyone can, I'll be grateful!

Hi.

I am using ahkDBA to connect to an SQLITE database successfully.

When I add a full text virtual table using the FTS 5 module of SQLITE, and use ahkDBA to generate a query against the database,, ahkDBA generates the error 'A non-object value was improperly invoked. Specifically: 0.'

When I add the same FTS table using the FTS3/4 module, the query runs.

The same error is caused by inserting an FTS5 table in the ahkDBA example database table using the Test table as a source for the FTS file.

Any ideas how to make an database using a FTS5 table work with ankDBA? They are a great combination.

using ahk 1.1.24.01 64 bit

In your example, and in my tests getColumnNames returns empty.

could you please post source for modified sqlite3 (64bit) ?
maybe as a separate repo...

I assume you are using System.Data.SQLite...
I dropped in the official download from System.Data.Sqlite.dll and renamed it to sqlite3.dll in the x64 folder.
select query works fine, but insertmany fails... (script works fine with 32 bit)

It completely ignores the possibility of specifying a relative path (which is essential in my case), and ignores the possibility of someone manually specifying a ":memory:" database.