On 6 Nov 2010, at 11:35pm, Tito Ciuro wrote: > My main question has to do with binding values to precompiled statements. For > the value column, should I: > > a) use sqlite3_bind_value()? > b) store it as a string using sqlite3_bind_text()? Will sqlite3_bind_text() > allow SQLite to choose the proper data affinity even though I'm binding it as > text?
Use the binder appropriate to the value you want to store and retrieve. Ignore the place the value will be stored, just worry about whether you're currently holding is typed an integer, text, real, etc.. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
