Thanks. I verified that by experimenting with the command-line sqlite3.exe application. I assume the rule is: changes within a transaction are only visible on that same connection. A different connection will only see changes after the transaction has been committed.
-Scott sqlite-users-boun...@sqlite.org wrote on 01/03/2011 10:52:23 AM: > Scott A Mintz <sami...@ra.rockwell.com> wrote: > > If I BEGIN a transaction and perform a number of INSERTS, UPDATES, and > > DELETES, then do a SELECT, will the data selected be the original > > unmodified data? > > On the same connection within the same transaction? No, you will see > the modified data. > -- > Igor Tandetnik > > _______________________________________________ > 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
