SQLite Forum

Confused about blobs
Login
I think I get it now. 

What I have been doing is using sprintf() to assemble a sql statement. So bind is sort of like doing a sprintf. A base string with variables that get replaced by some value using bind. So several calls to sqlite3 routines to build the statement sql. 

Is there an advantage to using several bind calls versus using a single sprintf call? or is just another way of doing the same thing?