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 <d...@sqlite.org> wrote: > On Wed, Jan 26, 2011 at 1:30 PM, Igor Tandetnik <itandet...@mvps.org> 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 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") >> > } >> >> If I recall correctly, this is not allowed in SQLite 3.5.*. This became >> supported in 3.6.x (for some x I don't remember at the moment). >> >> > I had a look at http://www.sqlite.org/lockingv3.html. >> >> The documentation describes the current behavior. Older versions often >> behave differently. 3.5 series are 2.5 years old, a lot of progress has >> been made since then. >> > > 2.5 calendar years equals 17.5 internet years, right? :-) > > >> -- >> Igor Tandetnik >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users