SQLite Forum

JOIN query behaves differently with/without trailing ON?
Login
Yes thanks, this is coming back to me.
Now my sqlite3.dll has no exports. 
How to enable that in the Makefile?

# These are additional compiler options used for the core library.
#
!IFNDEF CORE_COMPILE_OPTS
!IF $(DYNAMIC_SHELL)!=0 || $(FOR_WIN10)!=0
CORE_COMPILE_OPTS = $(CORE_CCONV_OPTS) -DSQLITE_API=__declspec(dllexport)
!ELSE
CORE_COMPILE_OPTS = $(CORE_CCONV_OPTS)
!ENDIF
!ENDIF

Bypassing nmake, I get a working dll with the following cmd:
c:\sqlite-snapshot-202004061816>cl sqlite3.c -DSQLITE_THREADSAFE -DSQLITE_DQS=0 -DSQLITE_MAX_ATTACHED=125 -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll