Hi,
My program model in effect was a Component based model whereby I created an Object Enumerator which is currently implemented as an SQLite Select Query and whilst enumerating the objects I was then calling Delete() on some objects to tell them to destroy.
The problem with SQLite was that i wasn't able to delete because the query was still active. I believe the best way to implement this is going to be to cache the results after creating the enumerator and then use the results cache to return an object from the enumerator.
Although i suppose I could try and do as you said and cache the objects to be deleted into a list and then destroy them at the end of the enumerator.
It's a pity it couldn't have been implemented in SQLite though to be more flexible.
Thanks anyway
Andrew -- Andrew Clark
