On Mon, 2011-02-21 at 15:13 +0100, Dietmar Hummel wrote: > std::string strStatement( "UPDATE persistence SET > name=\"blub\",expiration=\"2011-04-02\",value=\"?\" WHERE id=\"1\"" );
In addition to what Igor said, it isn't really proper (standard?) SQL to put double quotes around the value literals because these should be reserved for identifiers (e.g. schema, column or table names). I know that MS-Access (and probably SQL Server) allows it; perhaps SQLite does, too, but other databases won't -- you need to enclose them in single quotes (but only if the value is a string literal, or a date-time value formatted as a string). With some RDBMS's the character used to enclose identifiers is optional or configurable, e.g. the backtick character (`) used by MySQL. Bob _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
