Re: [sqlite] Nesting Read/Write within Transaction?

2010-02-12 Thread dv74
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:

[sqlite] Nesting Read/Write within Transaction?

2010-02-12 Thread dv74
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

[sqlite] Nesting Read/Transactions

2010-02-12 Thread dv74
-- 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