I do not find it to be the case, i.e. categorically, that “you can’t execute another query while you are fetching the results of an earlier one.”   (In fact, I just did it.)   As long as you are careful to use two separate statement-handles, it is perfectly okay to, for example, loop through one query and select each of the records in turn that are mentioned in that query.

I am therefore quite sure that I misunderstood the subtle point you were trying to make – which, I am entirely certain, must indeed have been correct or of course you wouldn’t have said it.   Therefore, could you please clarify your point?   An example of the specific “gotcha” that you are elucidating?   Thanks.