A Sqlite3 Database Example

[MrBcx]

A long time ago, Robert, Doyle, and I put together a demonstration app that created a Microsoft .mdb database file,
inserted a table into that database, populated some data into that table, updated some values inside that table,
queried the table and displayed the results in a BCX INFOBOX control.  It was an immensely informative and useful
demonstration.

Now many years later, it has become much more difficult to work with mdb files, so I though it would be a useful
exercise to convert the original demonstration app to use the Sqlite3 32-bit and/or 64-bit dll files.  I have succeeded
with that project and have decided to share it here.

Mingw, MSVC, and  Pelles C successfully compile and run the 32-bit and 64-bit Sqlite3.dll
Lcc-Win32 successfully compiles and runs the 32-bit Sqlite3.dll

Don't forget -- 32-bit dll's require 32-bit exe's -and- 64-bit dll's require 64-bit exe's.

The code in the attached zip compiles fine using BED.  Be sure to compile it as a console mode app.

The attached zip file contains everything you need:  the dll's, my exe's, and the source code.

By the way, I'm no expert with Sqlite3.  It took a few hours of trial and error to get everything
working the way it does in the demo.

I hope someone finds this useful. 

[dragon57]

Huge thanks for this!