"Joanne Pham" <joannekp...@yahoo.com> wrote in message news:677762.12434...@web90302.mail.mud.yahoo.com > Can we use one statement handle for both insert and select?
Of course not. When you call sqlite3_prepare, you pass the query text and get back the statement handle. The query can't begin both with SELECT and with INSERT, obviously. Why do you feel it would be beneficial to somehow "reuse" a statement handle for two different queries? What are you trying to achieve? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users