Re: [sqlite] How does _exec() do a transaction ?

2018-05-31 Thread Simon Slavin
On 30 May 2018, at 2:24pm, Simon Slavin wrote: > [something] Thanks to the mods, but I realised I'd posted this from a wrong address and resubmitted it from the right address. Already asked and answered. Thanks, everyone. Simon. ___ sqlite-users

[sqlite] How does _exec() do a transaction ?

2018-05-30 Thread Simon Slavin
Suppose I have no transaction open, and use _exec() with a multi-command string that has no transaction commands in. Does SQLite perform the whole _exec() in one transaction or each command in a separate transaction ? Simon. ___ sqlite-users mailing

Re: [sqlite] How does _exec() do a transaction ?

2018-05-30 Thread R Smith
On 2018/05/30 3:33 PM, Simon Slavin wrote: On 30 May 2018, at 2:30pm, Simon Slavin wrote: Does SQLite perform the whole _exec() in one transaction or each command in a separate transaction ? Subsidiary question: Does SQLite parse the entire string of commands for a syntax error first,

Re: [sqlite] How does _exec() do a transaction ?

2018-05-30 Thread Simon Slavin
On 30 May 2018, at 3:07pm, Abroży Nieprzełoży wrote: > sqlite3_exec doesn't open transaction by itself. > > Each statement is prepared and executed separately. Thank you for your fast answers. Simon. ___ sqlite-users mailing list

Re: [sqlite] How does _exec() do a transaction ?

2018-05-30 Thread Abroży Nieprzełoży
sqlite3_exec doesn't open transaction by itself. Each statement is prepared and executed separately. 2018-05-30 15:33 GMT+02:00, Simon Slavin : > On 30 May 2018, at 2:30pm, Simon Slavin wrote: > >> Does SQLite perform the whole _exec() in one transaction or each command >> in a separate

Re: [sqlite] How does _exec() do a transaction ?

2018-05-30 Thread Simon Slavin
On 30 May 2018, at 2:30pm, Simon Slavin wrote: > Does SQLite perform the whole _exec() in one transaction or each command in a > separate transaction ? Subsidiary question: Does SQLite parse the entire string of commands for a syntax error first, triggering an error if anything is wrong

[sqlite] How does _exec() do a transaction ?

2018-05-30 Thread Simon Slavin
Suppose I have no transaction open, and use _exec() with a multi-command string that has no transaction commands in. Does SQLite perform the whole _exec() in one transaction or each command in a separate transaction ? Simon. ___ sqlite-users mailing