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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users