On 10/18/2013 1:57 PM, Normand Mongeau wrote:
Also, the consuming should be a 2-step process because the processing is involved and may fail for reasons too long to explain here. So in essence, select a record, modify it to indicate it's being processed, and once the processing is done delete the record. Is there a way to do the initial selection in one swoop (select and update) or is it two SQL statements?
It must be two statements, but you can of course wrap them into a single explicit transaction.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
