2018-07-09 8:28 GMT+02:00 Hick Gunter <h...@scigames.at>: > Why should a failure in transaction #2 rollback transaction #1? >
I was thinking that, but was not sure. I thought that maybe everything in a call would be seen as a transaction. But that is not the case then: every statement in a call is its own transaction. > If you want this behaviour, do "begin; delete ...; insert ... on conflict > rollback; commit;" to make both statements run in one transaction > Is this standard SQL, or SQLite specific? > -----Ursprüngliche Nachricht----- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Cecil Westerhof > Gesendet: Montag, 09. Juli 2018 08:21 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [EXTERNAL] [sqlite] What happens when a call contains two SQL > statement > > I am working with Tcl. The best is of-course a general answer, but if it > is depending on the used language I will be satisfied with the Tcl answer. > ;-) > > Say I have the following code: > set SQLCmd " > DELETE FROM testing > WHERE key = 12 > ; > INSERT INTO testing > (key, value) > VALUES > (12, 'Just some text') > " > db eval ${sqlCmd} > > If the insert goes wrong, will the delete be rolled back, or not? > > I could use INSERT OR REPLACE, but the above code would be database > independent. > -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
