Compiling SQLite with Dev-C++

This is my first post. I am trying to manually compile SQLite 3.6.23 with Dev-C++ as a static library (I can always just download de DevPac, which comes precompiled, but I want to learn to do this by myself). I'm not sure which source code files I need to add to my project in order to compile it.

and many other similar errors. When I remove this file, sqlite3.c it seems to compile, as all I get is a message "creating libsqlite3.a".

My questions:
1. Can I use the libsqlite3.a I generated without the sqlite3.c file? Is it complete?
2. How do I add it to my programs?
3. Can I use the available precompiled dll (available from sqlite.org) instead? How would I do this?

You're not supposed to #include the C source. You're supposed to add it to the project. Right click on the project in the project explorer (or whatever it's called in Dev-C++. It's a treeview that lists the project and all the sources in it) and select "add files" or something, then choose sqlite3.c. This will compile the source into the final executable and get rid of that linker error you're getting.

"This is not a link issue, but a compiler one. SQLite is ANSI C, so you
should compile it with gcc. It will still be usable within your C++
library/project, as sqlite3.h qualifies all functions extern "C"."