Newbie question on SQLite

Databases
1

Hello everybody! Just a quick question which seems so crystal clear that I don’t find anything on Google about it: when I do a Database.BeginTransaction, followed by an update of some rows in a table with Database.ExecuteSQL("UPDATE tblExample...") and only after that I’m doing a Database.SelectSQL("SELECT * FROM tblExample..."), does the select include all the updates I made or only the values I had in the table before the BeginTransaction?

2

It has all the changes made inside the transaction.

1 Like
3

Thank you for the quick answer! That’s what I was hoping.

4

Also, if something fails after such select, before the .CommitTransaction(), causing a rollback, your collected data can be false, as changes were undone.