On Fri, Mar 21, 2008 at 07:09:29PM -0600, John Stanton scratched on the wall:
> Use this sequence -
>
>sqlite3_prepare_v2
> while not finished
>sqlite3_bind_xxx
>sqlite3_step
> until SQLITE_DONE
>sqlite3_reset
> repeat
>sqlite3_finalize
>
> The sqlit
Use this sequence -
sqlite3_prepare_v2
while not finished
sqlite3_bind_xxx
sqlite3_step
until SQLITE_DONE
sqlite3_reset
repeat
sqlite3_finalize
The sqlite3_reset readies the compiled statement for binding with
another value.
Derek Developer wrote:
> Jus
Just wanted to check that there is no "reset" statement that I can use with
UPDATE's.
My understanding is that for multiple Row updates the complete sequence needs
to be executed for each row ie:
"UPDATE mytable SET ' name=?, street=?, Phone=? WHERE ROWID=333"
Prepare
Bind the data
step
final
3 matches
Mail list logo