>When we execute a select sql statement, the tables used by the select remain open. Is there a way to clean that ? And keep the ones that were already open before the select ?
Just as a general idea (not tested at all), you could consider running a SELECT in a separate datasession - maybe by using a SESSION-based class.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up