Re: [sqlite] Multiple Row Updates

2008-03-22 Thread Jay A. Kreibich
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

Re: [sqlite] Multiple Row Updates

2008-03-21 Thread John Stanton
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: >

[sqlite] Multiple Row Updates

2008-03-21 Thread Derek Developer
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