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
