jeudi 5 juillet 2018

Search sqlite3 table for an integer using C++

I have an sqliteCpp wrapper for my sqlite3 and was wondering if there is a query to search for integer in 'Symcod' columns as shown below:

sym = 100;
SQLite::Statement query(db, "SELECT Symcod FROM RawData WHERE EXISTS Symcod = sym");

but this gives me an Syntax error. Is there a way I can search the table for a integer using a variable name?

Aucun commentaire:

Enregistrer un commentaire