> From within a BEGIN TRANSACTION and END TRANSACTION block, should I not > update the same row in a table more than once?
You can update it as many times as you need. > What are the exact limitations on what I can do during a Transaction? Do not update a table if there is some select statement currently active and using it. Active means you made at least one call to sqlite3_step and last call to sqlite3_step returned SQLITE_ROW. Pavel On Wed, Jun 1, 2011 at 10:00 AM, Ian Hardingham <i...@omroth.com> wrote: > Hey guys, thanks for all the help so far today. > > From within a BEGIN TRANSACTION and END TRANSACTION block, should I not > update the same row in a table more than once? What are the exact > limitations on what I can do during a Transaction? > > Thanks, > Ian > _______________________________________________ > 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