Yes, you call sqlite3_reset to finish the current query, then just call
sqlite3_step to start a new one.
Igor Tandetnik
nbiggs wrote:
Do you just pass the compiled statement back to the step function
again?
-----Original Message-----
From: Clay Dowling
Sent: Thursday, January 26, 2006 2:34 PM
Subject: RE: [sqlite] Re: Difference between finalize and reset.
nbiggs said:
What would be a good example of reusing the statement? Why not just
execute the SQL again?
Using reset saves the expense of parsing the SQL statement again. For
most desktop apps this isn't especially important, since the program
will
just spend its time waiting for user input anyway. It's very valuable
in
a transaction processing situation though, where the same query will
be used many times.
Clay Dowling
