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?
In other words, do I need to COMMIT before I see the changes reflected in 
a SELECT?

I can see use cases where I'd desire both behaviors.  1) SELECT reflects 
the original data  2) SELECT reflects new data.

-Scott
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to