One work around is to load the results of your SELECT into a TEMP table, then loop through the TEMP table to do your DELETEs. SQLite does allow you to delete, update, or insert tables from within the middle of a select as long as the tables being updated, deleted, or inserted are distinct from those being queried.
Hi,
Thanks I think I will indeed use a temporary table instead. It will probably use less memory and less hassle than me caching all the results myself.
Thanks again
Andrew -- Andrew Clark
