On 19 Jan 2011, at 5:35pm, James Berry wrote: > I'm trying to understand whether there's any problem with committing a > transaction while in the process of stepping over results.
Does the transaction you're committing have anything at all to do with the SELECT you're stepping through ? If you do the same SELECT after the transaction might the results have changed ? If so, it's a bad idea to do the two things at the same time. Read the results of the SELECT into one or more variables. Once you've finalized the SELECT, then make your changes. Better still, if possible phrase your changes as an UPDATE command with a WHERE clause. That way you don't need any SELECT statement at all. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
