C++ variable in sqlite query.

[romanromeo89]

I'm trying to write a simple sqlite query in c++ using visual studio 2010. My problem is that i can't use a c++ variable inside that query. I was not able to find the right syntax.

sqlite3_prepare_v2(handler, "SELECT * FROM grammateas WHERE username==X;", -1, &statement, 0);

where X i would like to use a variable.
In php and mysql is very simple, but here things are more complicated!
Τhanks in advance.

[Ancient Dragon]

You have to set the string before calling salite3_prepare().

std::string select;
std::string username = "AncientDragon";
select = "SELECT * FROM grammateas WHERE username = '" + username.c_str() + "'";
sqlite3_prepare_v2(handler,select.c_str(), -1, &statement, 0);

[romanromeo89]

Really thank you! Works great!