Besides the fact that I don't understand what you have meant by these lines:
> Select * from table where lookup_key = "ABC" > append save results to my list. I don't see anything unusual in your algorithm. What do you want us to verify (which you cannot verify yourself) and what do you find unusual in your actions? Pavel On Fri, Feb 12, 2010 at 10:50 AM, dv74 <d...@esko.com> wrote: > > Hi , > After reading http://sqlite.org/atomiccommit.html I think I should be able > to do the following without any hiccups: > > Begin Transaction > For all tables > Select * from table where lookup_key = "ABC" > for selected rows update certain column > insert new rows with lookup_key = "ABC" > Select * from table where lookup_key = "ABC" > append save results to my list. > End Transaction > > > Can you please verify this. > > Thank you. > -- > View this message in context: > http://old.nabble.com/Nesting-Read-Write-within-Transaction--tp27565519p27565519.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > 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