>Is there a way from keeping a SQL Select statement from leaving the tables open that is pulls from?
>
>I'm annoyed that if the tables are not already opem, it will open them (which is fine), but it leaves the tables open (i.e. USED).
>
>I wish it would close them back. Right now, I am doing a USE IN statement on about 4 tables to close them due to having been opended by a SQL Select statement.
Check
Class to close any cursors created after it was instantiated FAQ #31943
So, you would instantiate this class before the select, then release it.
If it's not broken, fix it until it is.
My Blog