I have for the most part successfully converted my large ~14 year program from TxQuery to TVirtualQuery (over 4500+ instances).

For the most part, my implementation of TVirtualQuery ALWAYS recreates the TVirtualQuery object. I have a few modules in my product where after so many recreations of TVirtualQuery, I get an EAccessError.

I have tried implementing a simple cleanup procedure to reuse an instance of a TVirtualQuery and it never works.

Thank you for the information. Please describe the specified situation in more detail. For this, compose and send us a small sample, which when executed causes the EAccessError error. You can send this sample using the e-support form(https://www.devart.com - the "Support"\"Request Support" menu)

The EAccessError is only caused after a lot of resets and it may/may not be caused by TVirtualQuery.

Back to my original question, could you please tell me how to reuse an instance of a TVirtualQuery to execute a NEW SQL statement with new SourceDataSets? The only way I have found to work is to delete previous instance of TVirtualQuery and recreate it (new).