How to use sqlite with Borland C++ Builder

I have sqlite3.dll but I'm assuming it's far more complex than simply including that file in a project and then using its functions. Even if it was I have literally no experience using pre-built DLLs with C++ Builder applications.

So my question is, How would I go about using sqlite in a Borland c++ builder application? As simple an explanation or step-by-step guide as possible is preferable as my ability to do anything beyond creating apps with C++ Builder is severely limited.

Failing that, is anyone aware of a web article that answers the same question? I'm aware that sqlite3 has its own documentation section but I found it hard t开发者_Python百科o follow and some vital links are broken.

Failing that... Is there a better way to create small-scale easy to write for a beginner apps that make use of a sql database?

Just to be clear - I don't want to make use of a sql server. I want to write something that at its minimum is an executable file, a database file, and a library file in the same directory. In other words something I can distribute easily.

edit: I'm using Borland C++ builder 2009.

Did you try sqlite amalgamation? Basically it's just one source file to include in your project. If you compile through, you can use it.

See http://www.sqlite.org/download.html.