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:
> 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
> finalize
>
> then the next row must complete the same sequence ie:
> "UPDATE mytable SET ' name=?, street=?, Phone=? WHERE ROWID=333"
> Prepare
> Bind the data
> step
> finalize
>
> Obviously I can do all these within a BEGIN/END TRANSACTION
>
> but was just wondering if there is any way to use the reset statement and
> update the ROWID?
>
> This would save a lot of time for large numbers of rows.
>
> Testing with Seinfeld data from Michael Owens excellent book:
> http://books.google.com/books?id=VsZ5bUh0XAkC&pg=PA75&lpg=PA75&dq=sqlite+seinfeld&source=web&ots=u42Lep_3F7&sig=A3whrQ0XJbW7DBQbPhyspKdHJuc&hl=en
> Download:
> http://www.apress.com/book/downloadfile/2847
>
>
> (also would love to figure out how to respond to my own threads. I cannot
> seem to find the link in the digests I am getting at my email account)
>
>
>
>
> ---------------------------------
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
> now.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
