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.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
