On 2 Dec 2010, at 4:39pm, Pavel Ivanov wrote: > I didn't see in OP's email any information on whether he updates the > same rows or same table as he selects, so I'd say this statement is > too harsh in general case. While select is executing you shouldn't > update the same rows that were returned, or could be returned > unless/after you updated them. Other than that it's not a big deal.
Yep, fair point. But I read his question as strongly suggesting that he's updating the rows that are returned. I could be wrong, though. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users