Subject Re: Release temporary table From Ken Mayer <dbase@nospam.goldenstag.net> Date Thu, 8 Nov 2018 06:50:19 -0800 Newsgroups dbase.getting-started On 11/8/2018 5:43 AM, Randy Waldman wrote: > Plus 12 user.  I have a program that loops and creates a report with a temporary table.  Second time that I try to run the report, I get an error that my TempTable is "in use by another".  How do I free my TempTable for re-use? > thanks, Randy > When the report closes, you may need to deactivate the query and release it ... If all else fails, this is not something I usually recommend, but sometimes brute-force is the way to go: close tables Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm