> On Sep 14, 2017, at 8:19 AM, Igor Tandetnik <[email protected]> wrote:
>
> I'm pretty sure this calls string::operator+=(char), appending to the string
> a character whose ASCII code happens to be char(data). Which is unlikely to
> be what you had in mind. I suspect you get a warning from the compiler on
> this line, about losing significant bits.
Somewhat off-topic, but stringstream is a much nicer way to build up a string
in C++. Use the "<<" operator to append things to it, i.e. strings, characters,
numbers, then call str() to convert it to a string.
#include <sstream>
std::stringstream s;
s << "INSERT INTO " << table_name << " (" << data;
// etc.
s << ")";
std::string str = s.str();
Also, as for invalid SQL: Use the `sqlite3` command-line tool to interactively
experiment with SQL statements until you're familiar with them. Once you have a
statement that does what you want. copy it out of the terminal and put it in
your code.
—Jens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
