Tito Ciuro <tci...@mac.com> wrote: > My main question has to do with binding values to precompiled statements. For > the value column, should I: > > a) use sqlite3_bind_value()?
No, except in certain special cases. You would normally have no way to obtain sqlite_value pointer, anyway. > b) store it as a string using sqlite3_bind_text()? Yes, if you have a piece of text to store, use sqlite3_bind_text. If you have an int to store, use sqlite3_bind_int. You get the idea. > Will sqlite3_bind_text() allow SQLite to choose the proper data affinity even > though I'm binding it as text? What's "proper data affinity"? I'm afraid I'm not familiar with this term. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
