> > Sqlite3_bind_text(Statement, S.c_str(), S.size() + 1, > > SQLITE_[TRANSIENT | STATIC?]); > > Drop +1. It's unlikely that you actually want terminating NUL to be > part > of the string in the database. >
Sorry, mixed that one with the nByte parameter of prepare_v2. It's "-1" in code though, so my program shouldn't exhibit a problem. I wrote the snippet in this email on the fly :). > > Is SQLITE_STATIC suitable for this situation? > > Yes, as long as "use statement" part involves calling sqlite3_reset or > sqlite3_finalize on Statement. So no accesses happen after a finalize or reset, perfect :). Thanks a lot for the help. - Sherief _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users