Re: [sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread James Berry
On Jan 19, 2011, at 10:03 AM, Richard Hipp wrote: > On Wed, Jan 19, 2011 at 12:35 PM, James Berry wrote: > >> I'm trying to understand whether there's any problem with committing a >> transaction while in the process of stepping over results. > > The ability to do this was

Re: [sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread Simon Slavin
On 19 Jan 2011, at 5:35pm, James Berry wrote: > I'm trying to understand whether there's any problem with committing a > transaction while in the process of stepping over results. Does the transaction you're committing have anything at all to do with the SELECT you're stepping through ? If

Re: [sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread Richard Hipp
On Wed, Jan 19, 2011 at 12:35 PM, James Berry wrote: > I'm trying to understand whether there's any problem with committing a > transaction while in the process of stepping over results. > > The following loop, in some kind of weird hybrid pseudo-code, tries to > illustrate what

Re: [sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread Igor Tandetnik
On 1/19/2011 12:49 PM, James Berry wrote: > > On Jan 19, 2011, at 9:43 AM, Igor Tandetnik wrote: > >> On 1/19/2011 12:35 PM, James Berry wrote: >>> I'm trying to understand whether there's any problem with committing a >>> transaction while in the process of stepping over results. >> >> I believe

Re: [sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread James Berry
On Jan 19, 2011, at 9:43 AM, Igor Tandetnik wrote: > On 1/19/2011 12:35 PM, James Berry wrote: >> I'm trying to understand whether there's any problem with committing a >> transaction while in the process of stepping over results. > > I believe COMMIT would fail while there is an outstanding

Re: [sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread Igor Tandetnik
On 1/19/2011 12:35 PM, James Berry wrote: > I'm trying to understand whether there's any problem with committing a > transaction while in the process of stepping over results. I believe COMMIT would fail while there is an outstanding statement on the connection. > The codes seems to be working

[sqlite] Effect of commit transaction while in process of sqlite3_step'ing?

2011-01-19 Thread James Berry
I'm trying to understand whether there's any problem with committing a transaction while in the process of stepping over results. The following loop, in some kind of weird hybrid pseudo-code, tries to illustrate what I'm doing: while stepping over results from a select statement, doing inserts