On Wed, Jun 01, 2011 at 10:17:02 -0400, Pavel Ivanov wrote:
> > 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
Actually insert, update and delete are OK. Drop and alter table are
a problem.
> active and using it. Active means you made at least one call to
> sqlite3_step and last call to sqlite3_step returned SQLITE_ROW.
--
Jan 'Bulb' Hudec <b...@ucw.cz>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
