Suppose I have an SQL statement like this: select somecol from mytable where myid=3 and badtext="usertext" and goodtext="somegoodtext"
Suppose further that the values of myid and goodtext are generated by reliably me whereas badtext is supplied externally. If I want to use a prepared statement here, is it OK to generate the myid and goodtext parts using the usual string methods from my host language, leaving only badtext as a bound variable, so that my prepared statement looks like this: select somecol from mytable where myid=3 and badtext=? and goodtext="somegoodtext" That would simplify my life. My other question relates to when the database is actually touched. Is it the case that statement preparation and variable binding do not affect the database itself and it's only when the prepared statement is actually executed that the database is touched and might generate an SQLITE_BUSY response? Thanks. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
