I got some code online that uses the SQLite3 library in a small C++ console program and pasted it in a new Code::Blocks project. Then in the project tree (left side pane), I right clicked and added sqlite3.c and it immediately went into the source folder below main.cpp. So far so good.
I need to put in here that I'd already downloaded the sqlite3 amalgamation file and saved it to my /home dir on Linux Mint. I then copied sqlite3.c and sqlite3.h into the new project folder before I added the sqlite3.c file to the project.
So, when I tried to build/run it, it died instantly with this error:
/home/fmc/Desktop/CB/SQLite_Test-001/main.cpp:3:10: fatal error: sqlite3.h: No such file or directory