How can I execute an SQLite statement in C++

Question

I have the following command which works fine on Linux Console. But to get the result to a cpp file I have to store it to file and then read it. But is there a way I can directly execute this command in C++.

/usr/bin/sqlite3 /etc/myDB/db/share.db "select path from folder_info where ftp='YES'"

Answer 1

As far as i understand your question you can use the SQLite3 c++ api which is described here