SQLite Forum

Help with compiling extension
Login
I'm trying to compile statement_vtab from https://github.com/0x09/sqlite-statement-vtab.

I've successfully compiled and run this in sqlite on Linux, but having difficulty on Win10.

The following seems to successfully compile:

i686-w64-mingw32-gcc -shared -o statement_vtab.dll statement_vtab.c

But when I try to use this (in SQLite version 3.36.0) ...

.load ./statement_vtab.dll

CREATE VIRTUAL TABLE temp_1 USING statement (( SELECT 1 ));

The test case crashes sqlite and a message box id is displayed with a generic error message: "A problem caused the program to stop working ...".

Any advice would be appreciated.