> - I can't read through a record set and use the data to execute updates. > For instance, some parsing exercise which cannot be completed using a > single SQL command. I have to store all the data locally, get to the > end of the query, then execute and update statements.
I've had this same problem. People posted here, and the docs claim "many readers, one writer". If I understand it correctly this situation fits that exactly but I still can't do updates while executing a select. Perhaps Dr. Hipp will clarify things?
