[sqlite] Result of multi-command _exec() that errors ?

2012-12-04 Thread Simon Slavin
(Yes, I know I should be preparing and binding for security reasons, but that doesn't work here.) What is the result when using _exec() on multiple statements when one of the statements errors ? I read this page: http://www.sqlite.org/c3ref/exec.html and I can't figure out whether execution

Re: [sqlite] Result of multi-command _exec() that errors ?

2012-12-04 Thread Simon Davies
On 4 December 2012 11:02, Simon Slavin slav...@bigfraud.org wrote: (Yes, I know I should be preparing and binding for security reasons, but that doesn't work here.) What is the result when using _exec() on multiple statements when one of the statements errors ? I read this page:

Re: [sqlite] Result of multi-command _exec() that errors ?

2012-12-04 Thread Simon Slavin
On 4 Dec 2012, at 11:13am, Simon Davies simon.james.dav...@gmail.com wrote: 3rd paragraph: If an error occurs while evaluating the SQL statements passed into sqlite3_exec(), then execution of the current statement stops and subsequent statements are skipped. Dammit. Missed it. Thanks.