Installing SQLiter (my current choice of sqlite modules for Blitzmax) can be rather painful. Searching the Blitzmax forums will turn up dozens of helpful threads that all have to be waded through to glean the information you need. I've already done this twice now, so to save myself time in the future, I'll list exactly how I got the module working this time around.

How to build SQLiter 1.5 in Blitzmax 1.22 on the PC

To begin, download and install 3.1.0-1 MinGW. This is a small, free C and C++ compiler. You'll also need Pyropixel's SQLiter module

In case it one day vanishes, you can download MinGW in this local .zip mirror file (17Mb) - but please go to René's site for the latest SQLiter version.

Now set your environment variables (in Windows XP):

•     Go into Control Panel and open the System Properties.  (Try holding the Windows key and tapping Pause/Break as a shortcut.)
•     Click Advanced.
•     Click Environment Variables.
•     In top list (user variables) create a New one called MINGW and set it to the path of your MinGW installation directory (e.g. C:\mingw)
•     Then Edit your PATH variable and add ;c:\mingw\bin on the end (alter the path if you installed MinGW elsewhere). 

      Thanks to grey alien for this list

Ctrl + D in the MaxIDE now builds all the core modules – which takes ages and you don't need to do!

Now,  to make Pyropixel's SQLiter module:

•     Place the pyropixel.mod and tm.mod in the MAIN mod folder (not pub.mod)
•     Edit line 8 of tm.mod sqlite.bmx from Module usr.sqlite TO Module tm.sqlite.
•     bmk makemods -a tm
•     bmk makemods -a pyropixel

You need to follow that order, or the linker will break. Obviously you will need to type the bmk commands into the command prompt, after having changed to your BlitzMax installations bin folder!

Disclaimer: I am just learning Blitzmax. These steps worked for me. I don't necessarily understand why! If they don't for you, best consult the Blitzmax forums.