Joanne, Igor was saying:
Assuming you are only doing one update either works and #2 is faster for you to implement. On the other hand, if there is a long list of id's to update, than #1 is faster if you only prepair the statement once and bind multiple times.
On a side note, with respect to your code: q = "UPDATE logTable SET stale = 1 WHERE id = "; sprintf(sqlStmt,"%s%d ",q,rpid); I don't know the source of the ID, I assume it is the system not a user, but if it is a user, use Parameterized SQL rather than this approach of SQL concatenation. For details, Google: sql injection attack Sam
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
