Re: [sqlite] Insert while select

2011-01-26 Thread Rich Rattanni
I was way off on the version. We are using 3.3.17. Sorry to bother you about behavior from Apr 25, 2007. I am simply curious to understand this behavior. On Wed, Jan 26, 2011 at 1:33 PM, Richard Hipp wrote: > On Wed, Jan 26, 2011 at 1:30 PM, Igor Tandetnik wrote: > >> On 1/26/2011 11:09 AM, R

Re: [sqlite] Insert while select

2011-01-26 Thread Richard Hipp
On Wed, Jan 26, 2011 at 1:30 PM, Igor Tandetnik wrote: > On 1/26/2011 11:09 AM, Rich Rattanni wrote: > > I am helping someone write an application that utilizes SQLite. The > > following code is giving us grief (sqlite lib version 3.5.ish - > > Windows XP): > > > > sqlite3_prepare("select some r

Re: [sqlite] Insert while select

2011-01-26 Thread Igor Tandetnik
On 1/26/2011 11:09 AM, Rich Rattanni wrote: > I am helping someone write an application that utilizes SQLite. The > following code is giving us grief (sqlite lib version 3.5.ish - > Windows XP): > > sqlite3_prepare("select some rows") > while (sqlite3_step() == SQLITE_ROW) > { > // Do some ca

Re: [sqlite] Insert while select

2011-01-26 Thread Simon Slavin
On 26 Jan 2011, at 4:09pm, Rich Rattanni wrote: > sqlite3_prepare("select some rows") > while (sqlite3_step() == SQLITE_ROW) > { >// Do some calc on multiple rows, and occasinally >sqlite3_exec("Insert calculated data into the same table from > which we are reading") > } > sqlite3_fin

[sqlite] Insert while select

2011-01-26 Thread Rich Rattanni
I am helping someone write an application that utilizes SQLite. The following code is giving us grief (sqlite lib version 3.5.ish - Windows XP): sqlite3_prepare("select some rows") while (sqlite3_step() == SQLITE_ROW) { // Do some calc on multiple rows, and occasinally sqlite3_exec("I