Re: [sqlite] Nesting Read/Write within Transaction?
I need a confirmation that these operations (i.e reading back the rows, that were just modified/inserted while the transaction is occuring) are valid and will not bite me in the long run. Pavel Ivanov-2 wrote: > > 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 > -- View this message in context: http://old.nabble.com/Nesting-Read-Write-within-Transaction--tp27565519p27566601.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] Nesting Read/Write within Transaction?
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] Nesting Read/Transactions
-- View this message in context: http://old.nabble.com/Nesting-Read-Transactions-tp27565385p27565385.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
