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_finalize()
Is there a chance that the INSERTs that he's doing would interfere in any way
with the SELECT ? In other words, if he executed an indentical SELECT after
doing all the INSERTs, would be definitely get the same results as he did
before ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
